SUMIF with only Month
thank you very much.
"Bruno Campanini" wrote:
"Tufail" wrote in message
...
Hello,
I want make sum, detail is as under.
I want sum if A/Coulm month=JAN, B/Coulm=Car, C/Coulm Amount
A B C
01-JAN-2006 CAR 500
05-JAN-2006 CAT 100
01-FEB-2006 BOOK 400
=SUMIF (A1:A10 "JAN" & B1:B10 "CAR",C1:C10)
Thanks in advance.
=SUMPRODUCT((A1:A10="JAN")*(B1:B10="CAR"),C1:C10)
Bruno
|