You didn't say what your date criteria was. This will sum where dates are
for December 2007:

Excel 2007 using SUMIFS:

=SUMIFS(C2:C5,A2:A5,"="&DATE(2007,12,1),A2:A5,"<= "&DATE(2007,12,31),B2:B5,"Rent")

Or, using cells to hold the criteria:

F1 = 12/1/2007
G1 = 12/31/2007
H1 = Rent

=SUMIFS(C2:C5,A2:A5,"="&F1,A2:A5,"<="&G1,B2:B5,"R ent")

Other versions of Excel (including Excel 2007):

=SUMPRODUCT(--(TEXT(A2:A5,"m/yyyy")="12/2007"),--(B2:B5="Rent"),C2:C5)

Or, using cells to hold the criteria:

=SUMPRODUCT(--(A2:A5=F1),--(A2:A5<=G1),--(B2:B5=H1),C2:C5)

--
Biff
Microsoft Excel MVP


"Trish" wrote in message
...
I am trying to sum column C using two criteria - dates, column A and text
"Rent" in Column B. Nothing I have tried works with the dates. Any
suggestions.

example

A B C D
12/1/07 Rent $500.00
12/31/07 Misc $100.00
1/1/08 Rent $500.00
1/10/08 Misc $100.00