gicals or formlasCount cells in a Range
Jim & Dave
Thank you both
--
Gary''s Student - gsnu200757
"Dave Peterson" wrote:
if the range is contiguous (and rectangular):
=rows(a1:c9)*columns(a1:c9)
Change the address to what you want.
Gary''s Student wrote:
What is the easiest wasy to count (without VBA) the cells in a range. I want
to count all the cells. Don't care if they are empty, filled with numbers or
text or logicals, for formulas. Just the raw count of cells.
--
Gary''s Student - gsnu2007q
--
Dave Peterson
|