How to sum values over a range of dates in Numbers

numbers

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

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)

You are correct in that you need to use the SUMIF function. This is the specification from the Function Browser:

SUMIF(test-values, condition, sum-values)

Try this in your cell:

=SUMIF(CATEGORY; "=HW"; POINTS)

Of course there may be other ways of doing this, but here is one.

To accomplish this dynamically (so that it changes when the current week changes), one can use the WEEKNUM( ) function.

Create a column (you can hide this later if you don't want it to show. See edit below) with the calculation of:

WEEKNUM( A1 ) -- Where A1 is the first cell with a date.

Now you can use this formula in a cell to get the sum for the current week.

SUMIF(Table 1::B,WEEKNUM(TODAY()),Table 1::C)

This should give you the desired result.

See the screen shot. The Function Inspector pane has more information on these functions.

Numbers Formula

EDIT

To hide a column: - Highlight the column - Click the disclosure arrow (or control click / right click) - Select Hide Column

To show again, right click in an adjacent column letter and select Unhide.

Hide column dialog