A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#NAME?



 
 
Thread Tools Display Modes
  #1  
Old August 28th, 2008, 06:23 PM posted to microsoft.public.excel.worksheet.functions
77Debbie77
external usenet poster
 
Posts: 9
Default #NAME?

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!!!!!
  #2  
Old August 28th, 2008, 06:30 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
 
Posts: 963
Default #NAME?

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

"77Debbie77" wrote in message
...
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!!!!!



  #3  
Old August 28th, 2008, 06:33 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default #NAME?

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

  #4  
Old August 28th, 2008, 06:35 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
 
Posts: 963
Default #NAME?

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



  #5  
Old August 28th, 2008, 06:42 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default #NAME?

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.

"Peo Sjoblom" wrote:

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




  #6  
Old August 28th, 2008, 06:54 PM posted to microsoft.public.excel.worksheet.functions
77Debbie77
external usenet poster
 
Posts: 9
Default #NAME?

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

"Duke Carey" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.