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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|