=SUMPRODUCT(--(A2:A2222,=--"2007-01-12"),--(A2:A2222,<=--"2007-02-11"),--(G
2:G2222="e"),D2:D2222)


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ladyofthewhitecity" wrote in
message ...
I have a spreadsheet of my personal spending and I want to sum up how much
I
have spent on a) luxuries and b) essentials ("l" and "e") in a particular
date range. I can get it to work if I ignore either the date range
criteria:

=SUMIF(G2:G1228, "e",D2:D1228)

or the essentials/luxuries criteria:


=SUMIF(A2:A2222,"<="&DATE(2007,2,11),D2:D2222)-SUMIF(A2:A2222,"<"&DATE(2007,
1,12),D2:D2222)

but how do I do both together?

Thank you!