G Guest May 21, 2005 #1 I am trying to make a sum... it need to do what a SUMIF does but it needs to ask 2 questions to get a answer
I am trying to make a sum... it need to do what a SUMIF does but it needs to ask 2 questions to get a answer
A Aladin Akyurek May 21, 2005 #2 Dan said: I am trying to make a sum... it need to do what a SUMIF does but it needs to ask 2 questions to get a answer Click to expand... And those questions are...
Dan said: I am trying to make a sum... it need to do what a SUMIF does but it needs to ask 2 questions to get a answer Click to expand... And those questions are...
B Bob Phillips May 21, 2005 #3 =SUMPRODUCT(--(rng1="value"),--(rng2=number),rng3) -- HTH RP (remove nothere from the email address if mailing direct)
=SUMPRODUCT(--(rng1="value"),--(rng2=number),rng3) -- HTH RP (remove nothere from the email address if mailing direct)
D Debra Dalgleish May 21, 2005 #4 You can use the SUMPRODUCT function when you have multiple criteria. There are instructions here: http://www.contextures.com/xlFunctions01.html
You can use the SUMPRODUCT function when you have multiple criteria. There are instructions here: http://www.contextures.com/xlFunctions01.html
