Calculate total number off cells with data in

[Gazza]

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?

 

[Jan Karel Pieterse]

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?

Check out the COUNTA worksheet function.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[CLR]

=COUNTA(YOURRANGE)

Vaya con Dios,
Chuck, CABGx3

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?

 

[Sam]

That worked! Thanks a bunch.

-----Original Message-----
Hi Gazza,

of cells with data in (data is alphanumerical) and display
the total number of cells with data in in a different
cell. Any ideas?

 

[Jan Karel Pieterse]

Hi Sam,

That worked! Thanks a bunch.

Great, thanks for letting us know!

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com