sumproduct problem

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have 3 arrays. month_rng,model_rng,and gross_rng. The
formula I am using is :

=SUMPRODUCT(Month_rng=SelectMonth,Model_rng="N
Lt",Gross_rng)

Which gives me a zero result. I am trying to use this to
be able to select the month I want and the Model I want
and then sum the gross with the request criteria. What am
I doing wrong.
 
Dan,

Try

=SUMPRODUCT((Month_rng=SelectMonth)*(Model_rng="N Lt")*Gross_rng)

HTH,
Bernie
MS Excel MVP
 
-----Original Message-----
One way

=SUMPRODUCT(--(Month_rng=SelectMonth),-- (B2:B10="NLt"),Gross_rng)

--

Regards,

Peo Sjoblom



The reason this works is because if the text statement is
Click to expand...
true than the result is one, if not it is zero.
Correct ????
I was using the Conditional Sumif and could not make this
work. Why would anyone use the Conditional Sumif since
this is so much easier. Also, when I try to type in the
formula I get a null result, but if I use the function
button and edit it, it works. I tried pressing
Ctrl+Shift+Enter and it still does not work. What am I
doing wrong
 
Back
Top