Is the COUNTA() Function Buggy?

This is a marvelous program, and it was well worth the wait, but at least one of the functions is a little dicey. When I apply COUNTA() to a named (header) column, it often gives a result that is much higher than the actual number of non-empty cells in the column. For example, when I created a column named Assistant (for Assistant Professor) and entered six faculty member names in that column, COUNTA(Assistant) returned eight rather than six. When I selected the empty cells below the faculty member names and hit Delete, I got the right answer, six. This led me to believe that Numbers was picking up something in the otherwise blank cells and treating them as non-empty. But there's more. If I then enter some text in another cell in Assistant column, skipping some, COUNTA(Assistant) returns nine; that is, it jumps from six to nine. I suspect that COUNTA() is not keeping track of the empty cells correctly and therefore is not updating correctly. Can anyone reproduce this problem?

Intel iMac, iBook G4, Mac OS X (10.4.9), HP Laserwriter, Edirol PCR-30

Posted on Sep 8, 2007 4:41 PM

Reply
10 replies

Oct 20, 2007 10:01 PM in response to Gregory Lypny

I am also getting mixed results with COUNTA.

It seems if the cell is totally empty, it is not counted. But if there is a formula in the cell (like IF(Something,"Name","") which returns a blank, it is counted.

My workaround is to use COUNTA-COUNTBLANK

COUNTBLANK does seem to work correctly, and counts the number of blank cells, so subtract it from COUNTA.

Please send feedback to Apple about this at
http://www.apple.com/feedback/numbers.html

so they can get it fixed.

Oct 21, 2007 5:55 AM in response to Terrell Smith

The problem is you formulas are in the range of data being counted. i.e. they are not in the footer row section. The program knows not to count data in headers and footers. Turn on footer rows, and move your counta to that cell. you will get the right answer again most likely.

If you think about it it makes perfect sense. Count teh actual number fo items, no matter if it is the counta or not, in the range your giving it.

Does that help explain a little better?
Jason

Oct 21, 2007 7:59 PM in response to jaxjason

Actually, that's not what's happening in my case, Jason. I do have my formula in the footer, and COUNTA counts not just one off, but 53 off! It counts cells which have a formula in them, but are otherwise blank.

The formula is =IF(H>=0.5,Home Country,"")
The IF statement puts the value from Column "Home Country" into the cell if the value in Column H is >=0.5, otherwise it's suppose to be blank.

COUNTBLANK counts the blank cells just fine, but COUNTA counts all the cells, blank as well as populated. I don't think that's how COUNTA is supposed to work.

Oct 22, 2007 12:17 AM in response to Terrell Smith

Hello

I don't know if it is a bug or a deliberate feature but it is true that COUNTA counts every cells in which something is entered. A formula is "something" so it is counted.

Reporting a description of this behaviour to the Numbers's team will help them to explain why its a feature or ecalade it if its a bug.

Yvan KOENIG (from FRANCE lundi 22 octobre 2007 09:17:01)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Is the COUNTA() Function Buggy?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.