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) |