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.