Add date condition

[MFS]

I am using this formula to sum amount.
=SUMIF(H2:H82;"=c";G2:G82)
H column including amount
G column including amount's nature D or C (Debit, Credit)

Now I want to add another condition, I want to specify date.
How I can adjust the formula by adding date condition, for example I want
only Feb 2008 Amount.

Please help me

 

[Bob Phillips]

=SUMPRODUCT(--(H2:H82="c");--(TEXT(F2:F82,"mmmyyyy")="Feb2008");G2:G82)

 

[David Biddulph]

You'll need SUMPRODUCT. See countless examples in this newsgroup.