Thread
:
won't calculate far enough
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
won't calculate far enough
Both you formulas work for me.
--
HTH
Sandy
with @tiscali.co.uk
"NTaylor" wrote in message
...
Hello,
I have a formula (see below) that will work for rows 2-1000, but once I
change it to look for columns beyond 2000, it will not work anymore... Any
suggestions?
This works:
=SUMPRODUCT(--('Q Info'!$A$2:$A$1000= 'Per Peice'!A9),'Q
Info'!$C$2:$C$1000*'Q Info'!$B$2:$B$1000)
This DOESN'T work:
=SUMPRODUCT(--('Q Info'!$A$2:$A$9999= 'Per Peice'!A9),'Q
Info'!$C$2:$C$9999*'Q Info'!$B$2:$B$9999)
--
Nicki Taylor
Reply With Quote