Thread: COUNTA function returns incorrect value
View Single Post
 
Old 10-15-2012, 01:56 PM
joeller joeller is offline Windows XP Office 2007
Novice
  
Join Date: Apr 2012
Posts: 7
joeller is on a distinguished road
Question 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
Reply With Quote