Getting the Count formula to count all rows

macropod · #4 08-23-2016, 12:26 AM

Quote:

Originally Posted by Jennifer Murphy

I found another document with a Count formula at the bottom of a column that had empty cells and it still worked. I've attach a simplified version of that document.

That's as expected - empty cells are counted.

Quote:

Originally Posted by Jennifer Murphy

It appears that you are correct about numbers, but not about text

Your table1 A3 confirms what I said - cells containing only text are not counted - they are treated as empty. By way of clarification, as soon as one of the cells to be counted contains a number, any non-numeric cells are ignored. It's more complicated than that too - any blanks above a numeric cell will cause the 'ABOVE' argument to function incorrectly. Try, for example, inserting numbers into cells D2, D5 & D7 of table A1, then updating the formula in D8.

Quote:

Originally Posted by Jennifer Murphy

This result makes no sense to me. What possible use could this have?

The ways of MS are sometimes inscrutable...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a formula to count all occurances of HH but multiply by 0.5 first	stupidgirl	Excel	6	06-14-2016 03:50 PM
simple way to count rows in a table?	bkcell	Word	4	03-09-2015 09:06 PM
Word Count Formula	clau_dos	Word VBA	1	08-27-2013 02:05 PM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM