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
|