How can I add a column of names for example

  • Thread starter Thread starter christina
  • Start date Start date
This formula counts the number of non-blank cells in A2:A5
=COUNTA(A2:A5)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Ron Coderre said:
This formula counts the number of non-blank cells in A2:A5
=COUNTA(A2:A5)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
That didn't work it hasn't worked for 48 hours now

This is what shows as my formula in the total field, I'm using excel 2007

=COUNTA(A154:A157)
 
If you see the formula, instead of the results
....it sounds like you have Formula Display turned on.

In Excel 2003, you can toggle the setting on/off
by using Ctrl+~ .....that's: Hold down CTRL and press the ~ key

See if that works in XL2007.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
You're welcome, Christina.....I'm glad I could help.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

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

How can we group rows? I have problem.... 2
Use of the Contents of a cell as a worksheet name in a function 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add cells 3
Hiddening Rows in an embedded worksheet 4
Combining Columns 2
Drop down boxes in VBA 1
Access Window Access Table overwirte? 1

Back
Top