Getting the Count formula to count all rows

macropod · #1 08-23-2016, 07:57 PM

FWIW, if you have another column filled with numeric data (e.g. your column D), you could use:
{=COUNT(D : D)-1}
with or without the spaces either side of the : I included them in my post because otherwise the forum software messes with the formula.
Note: the -1 subtracts the count of the Totals row.

Jennifer Murphy · #2 08-23-2016, 09:26 PM

Quote:

Originally Posted by macropod

FWIW, if you have another column filled with numeric data (e.g. your column D), you could use:
{=COUNT(D : D)-1}
with or without the spaces either side of the : I included them in my post because otherwise the forum software messes with the formula.
Note: the -1 subtracts the count of the Totals row.

Wow! That works. But why doesn't the formulas I have work when there is only 1 row? Why? Why? Why?

It's driving me nuts.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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