Numbers SUMIF by dates within current week?
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.


Drag this formula down the column.


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.







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.