ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DATE (https://www.excelbanter.com/excel-worksheet-functions/151786-date.html)

Jamal A M

DATE

I am having three columns
DATE, DESC, AMOUNT

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

Thanks & Regards

Mike H

DATE

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

"Jamal A M" wrote:

I am having three columns
DATE, DESC, AMOUNT

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

Thanks & Regards

Toppers

DATE

=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

"Jamal A M" wrote:

I am having three columns
DATE, DESC, AMOUNT

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

Thanks & Regards

All times are GMT +1. The time now is 12:50 PM.