yes now working, really thank you very much.

"Andy" wrote:

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