Sumif

[LadyDi]

I need to sum the dollar values in a column based on two criteria (the salesman and the month). How can I do that? I try using the SUMIF formula, but can only enter one criteria in that formula.

 

[Brianwarnock]

Apparently you can on 2007, but otherwise, or if that's wrong use Sumproduct.

Sumproduct((dollerarray)*(istcritarray=criteria)*(2ndcriteriaarray=))

say
Sumproduct((a1:a10)*(b1:b10="sales")*(c1:c10=mth))

Brian

Guide to sumproduct

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

 

[LadyDi]

Thank you so much! That worked just like I needed it to. You just saved me a ton of time. Thank you again!

 

[Brianwarnock]

Glad I could help.
If you are going to work with Excel keep the Sumproduct link it is an amazing function.

Brian