Excel 2003 - workinf with SUMIF for a range of dates

[nubbin]

This sheet is optimised for Excel 2003!
Ok, please take a look at this spreadsheet I'm making:
http://www.nubbin.org/Training.xls
(same as the attached file)
And look at the "Totals" worksheet within it. Cell G5, to be exact.
Here's my goal: I want to be able to look at the data on the "Input
sheet, and add up the miles I've run in the last 7 days.
I have two problems.
1) The formula in "Totals!G5" SHOULD (I think) be able to add up al
data regardless of "Activity" - but it doesn't.
2) I need to know how to add *2* "criteria" to my SUMIF formula
stipulating the dates, AND the activity.

Any help would be MUCH appreciated

Attachment filename: training.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50822

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((Input!A2:A12>TODAY()-7)*(Input!B2:B12=activity
type),Input!E2:E12)

or as alternative syntax:
=SUMPRODUCT(--(Input!A2:A12>TODAY()-7),--(Input!B2:B12=activity
type),Input!E2:E12)