| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Devise a formula to add non numerical data
How do I devise a formula that will add the number of items (non numerical
vaule) placed in a column? I am making a list and I want to create a formula that would add all of the entries that I add to the list. Basically, calculating how may items are in the list. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Devise a formula to add non numerical data
You can use
Count --- This will count up all the cells with values that you have selected Counta --- This will count all cells in the range including blanks Countif--- You can count cells that meet a certain criteria "Karin-LRC" wrote: How do I devise a formula that will add the number of items (non numerical vaule) placed in a column? I am making a list and I want to create a formula that would add all of the entries that I add to the list. Basically, calculating how may items are in the list. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Devise a formula to add non numerical data
Counta exclude blanks.
Gord Dibben MS Excel MVP On Mon, 10 Nov 2008 16:45:00 -0800, akphidelt wrote: Count --- This will count up all the cells with values that you have selected Counta --- This will count all cells in the range including blanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting numerical data | Excel Discussion (Misc queries) | |||
| Numerical data formula | Excel Worksheet Functions | |||
| Charting Non-Numerical Data | Excel Discussion (Misc queries) | |||
| extracting numerical data | Charts and Charting in Excel | |||
| Non-numerical data in a pie chart | Excel Discussion (Misc queries) | |||
Hybrid Mode
