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