|
|
#1
10-15-2012, 01:56 PM
|
|||
|
|||
COUNTA function returns incorrect value
I exported a report from SSRS to Excel.
Then I added a linebreak at F35 and entered cell with counta(F:32,F34) It returned a value of 2. (All lines contain data.) I entered another line break and another COUNTA function this time with the range COUNTA(F:37, F:42) It also returned a value of 2. This is with Excel 2007. Has anyone heard of this issue and how to resolve it?  Update: Used drag and drop in excel to create function. the format is F32:F34 for a range whereas separated by commas is for each individual cell. Now it works. Last edited by joeller; 10-15-2012 at 02:18 PM. Reason: Correction 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to release hard returns?
|
markg2 | Word | 13 | 05-08-2023 01:38 PM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
|
No tabbing, no returns in forms?
|
rdowney1 | Word | 7 | 06-29-2012 08:35 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
| Password is incorrect--but it's not. | orcasguy | Outlook | 2 | 11-10-2011 02:17 PM |
Windows XP 
Office 2007
Threaded Mode