what is sumproducts cell limit?

[ryan.fitzpatrick3]

what is sumproducts cell limit? I have a sumproduct that pulls a:6 to
a:5000, b6:b5000, etc and it works but when I extend sumproduct to
search for a6 to a50000, b6 to b50000 it says #VALUE. Why?

 

[Bob Phillips]

It is not the cell limits, SP will do all but one row in pre-2007 Excel, it
must be something in the data.

 

[ryan.fitzpatrick3]

My next problem is that when I pull the information it'll use the
sumproduct code which is on sheet1

=SUMPRODUCT(--(1*'Pulled from Access'!$B$7:$B$5420=OJ!$A11),--
(1*'Pulled from Access'!$C$7:$C$5420=OJ!$C11),--(1*'Pulled from
Access'!$I$7:$I$5420=MONTH(DATEVALUE(OJ!E$10&" 1, 2007"))),--('Pulled
from Access'!$J$7:$J$5420=$K$8),--('Pulled from Access'!$H$7:$H
$5420="R"),'Pulled from Access'!$G$7:$G$5420)-SUMPRODUCT(--(1*'Pulled
from Access'!$B$7:$B$5420=OJ!$A11),--(1*'Pulled from Access'!$C$7:$C
$5420=OJ!$C11),--(1*'Pulled from Access'!$I$7:$I
$5420=MONTH(DATEVALUE(OJ!E$10&" 1, 2007"))),--('Pulled from Access'!$J
$7:$J$5420=MID($K$8,3,2)),--('Pulled from Access'!$H$7:$H
$5420="I"),'Pulled from Access'!$G$7:$G$5420)

and it'll bring up the results from the posted list from access on
sheet3

but when I add another sheet, sheet2 and put the same equation in
(except that I make it meet the new item # requirements). and it'll
show the values but right before the calculation ends it turns the the
correct totals into #VALUE. Why does it do this? I mean it'll show the
correct values on both pages but before it finishs on both pages the
end result show up as #VALUE.

 

[Bob Phillips]

I cannot say I am afraid, I have efar too little information to work on. I
would need to see the workbook in action.