3

I have the following formula

SUMIFS(Daily Log::Income,Daily Log::A,"≥"&A3,Daily Log::A,"<"&A4)

that I want to sum income over the associated month. As you can see, it's not doing what I am expecting it to—how can I effect what I need?

enter image description here

7

It works by dereferencing the value of a cell directly to the condition

Example:

SUMIFS(Daily Log::Income,Daily Log::A,">=2014-07-01",Daily Log::A,"<2014-08-01")

Referencing the cell could also be made possible with the same construct; by adding ampersand followed by the cell name outside the double quotes.

Example:

SUMIFS(Daily Log::Income,Daily Log::A,">="&A3,Daily Log::A,"<"&A4)
  • 1
    Thanks; this didn't exactly answer the question, but it led me to it! Numbers doesn't understand the Unicode that I used; replacing it with the >= composite fixed the issue :) If you edit to include this information, I'd be more than happy to give you the tick. (And welcome to Apple.SE!) – Sean Allred Oct 16 '14 at 13:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .