Calculate total number off cells with data in

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

Guest

Hi All

Hope I find you well

I have a spreadsheet that has a number of cells that may or may not have data in them depending on curtain criteria. What I would like to be able to do is count the number of cells with data in (data is alphanumerical) and display the total number of cells with data in in a different cell. Any ideas?
 
Hi Gazza,
What I would like to be able to do is count the number of cells with data in (data is alphanumerical) and display the total number of cells with data in in a different cell. Any ideas?
Click to expand...

Check out the COUNTA worksheet function.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
=COUNTA(YOURRANGE)

Vaya con Dios,
Chuck, CABGx3


Gazza said:
Hi All,

Hope I find you well.

I have a spreadsheet that has a number of cells that may or may not have
Click to expand...
data in them depending on curtain criteria. What I would like to be able to
do is count the number of cells with data in (data is alphanumerical) and
display the total number of cells with data in in a different cell. Any
ideas?
 
That worked! Thanks a bunch.
-----Original Message-----
Hi Gazza,
Click to expand...
of cells with data in (data is alphanumerical) and display
the total number of cells with data in in a different
cell. Any ideas?
 
Back
Top