Sumproduct problem

[percy83]

Hi all,

I have been sitting with Excel now a few hours and am getting a little bit tired.

I am trying to put together three paralell ranges. This is the formula that I am trying to work out

=SUMPRODUCT((--(O_week_flooring=$C6)+--(O_week_lighting=$C6)+--(O_week_wardrobes=C$6));--(Region=D$5))

The result I get is 6 but should be atleast 13. What am I doing wrong?

Thanks

 

[Steve=True]

Not sure why you are getting your results but perhaps try ";" instead of a "*"

 

[Jonmo1]

I think you're looking to do an OR with the first 3 criteria right?

o_week_flooring or lighting or wardrobes = C6
AND Region =D5

Right?

Try

=SUMPRODUCT(--((O_week_flooring=$C6)+(O_week_lighting=$C6)+(O_week_wardrobes=C$6)>0);--(Region=D$5))