SUMPRODUCT - Error #NUM!

  • Thread starter Thread starter litos_aldovea
  • Start date Start date
L

litos_aldovea

Hi all,

I hope someone can explain me why this formula doesn't work

=SUMPRODUCT(('Retail 2003'!$A:$A=$H$1)*('Retai
2003'!$D:$D<=$N$1),'Retail 2003'!$Q:$Q)

delivering the error #NUM!

And the following does work properly

=SUMPRODUCT(('Retail 2003'!$A$1:$A$65535=$H$1)*('Retai
2003'!$D$1:$D$65535<=$N$1),'Retail 2003'!$Q$1:$Q$65535)

I just can't understand why Excel is not picking up the first one.

Thanks in advance,

Carlos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Sumproduct;3 criteria 5
Need Help With SUMPRODUCT 7
Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!! 2
SUMPRODUCT column criteria 2
SUMPRODUCT #N/A error 7
SUMPRODUCT 6
SUMPRODUCT formula doesn't work! 5

Back
Top