View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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