ExcelBanter - Sum (or Count) Total for a Column of Text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum (or Count) Total for a Column of Text (https://www.excelbanter.com/excel-discussion-misc-queries/211891-sum-count-total-column-text.html)

168rockwood

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?

JMay

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?

All times are GMT +1. The time now is 02:43 PM.