sumproduct problem

[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.

 

[Bernie Deitrick]

Dan,

Try

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

HTH,
Bernie
MS Excel MVP

 

[Peo Sjoblom]

One way

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

 

[Dan]

-----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

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

 

[Frank Kabel]

Hi
try

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