SUMPRODUCT - Error #NUM!  
Author Message
SeanMackey





PostPosted: Tue May 11 11:19:47 CDT 2004 Top

Excel Misc >> SUMPRODUCT - Error #NUM!

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

--
Message posted from http://www.hide-link.com/

Excel58  
 
 
Don





PostPosted: Tue May 11 11:19:47 CDT 2004 Top

Excel Misc >> SUMPRODUCT - Error #NUM! sumproduct cannot work on entire columns. use a1:a1000

--
Don Guillett
SalesAid Software



> Hi all,
>
> I hope someone can explain me why this formula doesn't work
>
> =SUMPRODUCT(('Retail 2003'!$A:$A=$H$1)*('Retail
> 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)*('Retail
> 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.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>