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.
|