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

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

"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.

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

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

Thanks for the feedback!
Andy.

"Tufail" wrote in message
...
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