I need a formula like someif but with more ifs?

[RichB]

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]

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