View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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