How can I add a column of names for example

[christina]

I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names
= 2

 

[Ron Coderre]

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)

 

[christina]

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)

 

[christina]

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)

 

[Ron Coderre]

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)

 

[christina]

Thank you so much that worked finally I appreciate your help.

 

[Ron Coderre]

You're welcome, Christina.....I'm glad I could help.

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

Regards,

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