Array
 

I have values from a2:a500 which contains various dates(not sorted) and
amount in b2:b500.

I would like to sum, where month(a2:a500) represents my values in
c2:c13(Jan,Feb ... Dec)

Please advice ...

TIV.

Array
 

in D2:

=SUMPRODUCT(--(MONTH($A$2:$A$500)=MONTH(C2)),$B$2:$B$500)

where C2=01/01/2007 i.e. 1st January (for any year) formatted as "mmm"
C3=01/02/2007 i.e. 1st February (for any year)


Copy down to C13

"Amul" wrote:

I have values from a2:a500 which contains various dates(not sorted) and
amount in b2:b500.

I would like to sum, where month(a2:a500) represents my values in
c2:c13(Jan,Feb ... Dec)

Please advice ...

TIV.

Array
 

In D2:

=SUMPRODUCT(B2:B500*(TEXT(A2:A500,"mmm")=C2))

HTH
Kostis Vezerides

On Jul 25, 11:50 am, Amul wrote:
I have values from a2:a500 which contains various dates(not sorted) and
amount in b2:b500.

I would like to sum, where month(a2:a500) represents my values in
c2:c13(Jan,Feb ... Dec)

Please advice ...

TIV.