D
Dan
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
ask 2 questions to get a answer
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aladin Akyurek
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
And those questions are...
B
Bob Phillips
=SUMPRODUCT(--(rng1="value"),--(rng2=number),rng3)
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
Debra Dalgleish
You can use the SUMPRODUCT function when you have multiple criteria.
There are instructions here:
http://www.contextures.com/xlFunctions01.html
There are instructions here:
http://www.contextures.com/xlFunctions01.html