COUNTA function returns incorrect value

[joeller]

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.

[macropod]

For testing the range F32:F34 or F37:F42, your COUNTA expression is wrong. It should be:
=COUNTA(F32:F34)
=COUNTA(F37:F42)
Now, whether COUNTA will report anything other than 2 for either range depends on what, if anything, the referenced cells contain.

[joeller]

Please note update at bottom of original entry edited yesterday 5:18 PM EDT.