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!