SUMIF
Hi
Don't quite know why this is in programming, but here goes:
=SUMPRODUCT((A2:A50="CAT")*(B2:B50="RAT")*(C2:C50) )
Hope this helps.
Andy.
"Tufail" wrote in message
...
hello,
i want make sum, if A_col=CAT B_col=RAT
A_col B_col C_col
CAT RAT 200
APPEL MILK 100
Thanks
|