SUMIF

[Guest]

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

 

[Guest]

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.

 

[ikr]

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.

 

[Guest]

yes now working, really thank you very much.

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.

 

[Joergen Bondesen]

Hi Tufail

Try this, please.

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

 

[Guest]

Thanks for the feedback!
Andy.

yes now working, really thank you very much.