Hi Tufail

Try this, please.

=SUMPRODUCT((A2:A7="Cat")*(B2:B7="Rat")*(C2:C7))

--
Best Regards
Joergen Bondesen


"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