SUMIF
 

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

SUMIF
 

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

SUMIF
 

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

SUMIF
 

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

SUMIF
 

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

SUMIF
 

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