Sum values if they occurred during current week

[lday75]

I have a checkbook transaction sheet that contains a category column. I also have a category table (named range) that sums up all the values from the transaction log for each category. I.E. Withdrawls, there may be 10 totaling up to 1000.00 over the course of say three weeks. In the category table it totals all of the 10 different transactions up with Withdrawls as the category.

What I would like to do is to have a separate category table that only tracks the transactions made during the current week and DOES NOT include any of the transactions from the prior weeks.

Currently my transaction log table section is from columns E - K. The Date column is Col F and the Category column is Col H, the formula in my current category table is as follows:

=SUMIF(MyTransactions[Category],"=" &CategoryTable[[#This Row],[Category]],MyTransactions[Withdrawal])

So, basically what I need to know is how to include an IF (the date in Col F is) WITHIN THE CURRENT WEEK to the formula above. I have not been successful with a variety of formulas I have tried so far.

Thoughts Anyone?

[daddylonglegs]

How do you define "during the current week"? Asssuming that means on or after last Monday then given you can get last Monday with this formula

=TODAY()-WEEKDAY(TODAY(),3)

try adding this criteria

=SUMIF(......,MyTransactions[Date],">="&TODAY()-WEEKDAY(TODAY(),3))

[lday75]

Thank You daddylonglegs,

Would be on or after last Sunday.

I have tried the formula and I am getting the, you have entered to many arguments for this formula error. Other than that, excel 2007 help is not all that helpful. That is why I come out here where the experts hang!!