| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum (or Count) Total for a Column of Text
I have a very simple spreadsheet. In Column A I have employee's names listed.
How do I create a formula or what do I select in order to count and get the total sum for the number of employees I have in that Column A? In order words, how can I get the sum of a list of items in a column that only has text? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum (or Count) Total for a Column of Text
how can I get the sum of a list of items in a column that only has
text? =SUMPRODUCT(ISTEXT(A3:A100)+0) "168rockwood" wrote: I have a very simple spreadsheet. In Column A I have employee's names listed. How do I create a formula or what do I select in order to count and get the total sum for the number of employees I have in that Column A? In order words, how can I get the sum of a list of items in a column that only has text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
