L LadyDi Registered User. Local time Yesterday, 21:50 Joined Mar 29, 2007 Messages 894 Jan 16, 2009 #1 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.
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 Retired Local time Today, 05:50 Joined Jun 2, 2003 Messages 12,701 Jan 16, 2009 #2 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
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
L LadyDi Registered User. Local time Yesterday, 21:50 Joined Mar 29, 2007 Messages 894 Jan 16, 2009 #3 Thank you so much! That worked just like I needed it to. You just saved me a ton of time. Thank you again!
Thank you so much! That worked just like I needed it to. You just saved me a ton of time. Thank you again!
Brianwarnock Retired Local time Today, 05:50 Joined Jun 2, 2003 Messages 12,701 Jan 16, 2009 #4 Glad I could help. If you are going to work with Excel keep the Sumproduct link it is an amazing function. Brian
Glad I could help. If you are going to work with Excel keep the Sumproduct link it is an amazing function. Brian