gicals or formlasCount cells in a Range

G

Gary''s Student

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.
 
J

Jim Cone

Hi,
Try...
=COUNTA(A5:D8)+COUNTBLANK(A5:D8)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Gary''s Student"
wrote in message
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.
 
D

Dave Peterson

if the range is contiguous (and rectangular):

=rows(a1:c9)*columns(a1:c9)

Change the address to what you want.
 
Top