|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 28th, 2008, 06:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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!!!!! 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode