"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
Use =SUMPRODUCT for multi-criteria. See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html.
Your formula will be something like
=SUMPRODUCT((A_col="CAT")*(B_col="RAT")*C_col) where A_col, B_col etc are
range names for the data ranges in cols A, B etc. They can be the entire
column, if you want. However, these column ranges MUST refer to the same
rows, otherwise SUMPRODUCT will throw up an error.