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