DATE

[Jamal A M]

I am having three columns
DATE, DESC, AMOUNT

I want sum the amount based on month of the date-column ( Not sorted).

Thanks & Regards

 

[Guest]

Hi,

Try this

=SUMPRODUCT((MONTH(A2:A17)=1)*(B2:B17="Whatever")*(C2:C17))

Where the 1 is january so change to suit. Note that this could be a cell
reference where you could put the month to sum.

Mike

 

[Guest]

=SUMPRODUCT(--(month(a2:a100)=7),c2:c100)

will sum month of July (all years)

=SUMPRODUCT(--(month(a2:a100)=7),--(Year(a2:a100)=2007),c2:c100)

July 2007

It's better to put your comparator values in cells:

=SUMPRODUCT(--(month(a2:a100)=X1),--(Year(a2:a100)=X2),c2:c100)

X1=7, X2=2007

HTH