gicals or formlasCount cells in a Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
if the range is contiguous (and rectangular):

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

Change the address to what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=Countif(range, criteria) 2
Excel Need Countifs Formula Help 0
Count cells in a range 2
Excel VBA 1
Count cells in a range 1
Count with merged cells 2
Count Highlited Cells 3
Count non-blank cells? 8

Back
Top