Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names
= 2 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
"Ron Coderre" wrote: 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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
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" wrote: 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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
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" wrote in message ... 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" wrote: 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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
Thank you so much that worked finally I appreciate your help.
"Ron Coderre" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I add a column of names for example
You're welcome, Christina.....I'm glad I could help.
-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "christina" wrote in message ... Thank you so much that worked finally I appreciate your help. "Ron Coderre" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names = 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel |