Thread
:
won't calculate far enough
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
won't calculate far enough
Not really, what exactly do you mean by:
This DOESN'T work:
what return do you get? Error message? Zero? Wrong sum? What?
--
Regards
Sandy
with @tiscali.co.uk
"NTaylor" wrote in message
...
Do you know why mine wouldn't? It looks like it will only go as far as
row
4000, and then the formula doesn't work any more. Does mine have a limit
or
something?
Thanks
--
Nicki Taylor
"Sandy Mann" wrote:
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