Good point, I didn't even think about that since name errors are so rare
in this regard

--


Regards,


Peo Sjoblom

"Duke Carey" wrote in message
...
most likely one of those columns has the #Name error in it.

Go to your huge data sheet, press the F5 key, click on Special, and choose
Formulas. Uncheck all but the Error option, then click on OK

Fix your issue there and you should be OK


"77Debbie77" wrote:

I am pulling my hair out!!! I have over 60,000 rows of data with comments
and
am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of
70108'!$E$2:$E$65141="B"),--('Closed calls as of
70108'!$F$2:$F$65141=""))
and I get the #NAME? error. I tried following the help under Excel but
haven't gotten anywhere! Column F equals the comments column and I want
all
blank cells added so I have: Col E=B, Col F=2,000 out of a total of
33,000.

I am using Excel 2003

PLEASE HELP!!!!!