Hi,

If you want to sum all the numbers in D9:D55202 where column F has groceries
and column E has a date greater then the date in A1, then something like
this should work

=sumproduct(('1563'!$F$9:$G$55202="groceries")*('1 563'!$E$9:$E$55202=A1)*('1563'!$D$9:$D$55202))

A1 has the date

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Kane" wrote in message
...
I am using Excel 2007. How can I modify sumif formula to sum only cells
that
meet the sumif and date range critiera?

=SUMIF('1563'!$F$9:$G$55202,"groceries",'1563'!$D$ 9:$D$55202)

-btw, it is near impossible to search the discussion group right now to
find
recent postings. And the nofication of replies is not working as well in
the
discussion groups.