#NAME?

[77Debbie77]

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

 

[Peo Sjoblom]

You probably have an error in your sheet name, it's better to let Excel do
the job, when you enter the formula click on the sheet tab of Closed calls
as of 70108 and you will get the exact name and apostrophes, then just enter
the rest.

--


Regards,


Peo Sjoblom

 

[Duke Carey]

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

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Duke Carey]

Debbie -

Given how big your data sheet is, you may be best off if you select column E
and F and THEN follow the steps to locate the error. It'll really labor to
check all the cells if you don't limit where Excel should look.

 

[77Debbie77]

OMG!!!!!!!!!!!!!!!!!!!!!!! Three cells out of 61414 cells have literally
#NAME? in them because ppl don't know how to type!! LOL!!! THANK YOU SOOOOOOO
MUCH!!!!