C
christina
I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names
= 2
= 2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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)
=COUNTA(A2:A5)
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
C
christina
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)
C
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)
This is what shows as my formula in the total field, I'm using excel 2007
=COUNTA(A154:A157)
R
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)
....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)
C
christina
Thank you so much that worked finally I appreciate your help.
R
Ron Coderre
You're welcome, Christina.....I'm glad I could help.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)