Add date condition
 

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
--
MFS22

Add date condition
 

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


--
__________________________________
HTH

Bob

"MFS" wrote in message
...
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
--
MFS22

Add date condition
 

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

"MFS" wrote in message
...
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
--
MFS22