I need a formula like someif but with more ifs?

Guest · Nov 20, 2004

I want to add the prices I have in column C if column A is x and column B is
Y? SUMIF is like what I need but with more ifs. Does that make sense?

JulieD · Nov 20, 2004

Hi

yes, check out SUMPRODUCT
=SUMPRODUCT(--(A1:A100="x"),--(B1:B100="Y"), C1:C100)

for a good write up on how sumproduct works check out

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Cheers
julieD

I need a formula like someif but with more ifs?

Guest

JulieD