ExcelBanter - How do I count the amount of text in a column and then add them

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

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

- - How do I count the amount of text in a column and then add them (https://www.excelbanter.com/excel-discussion-misc-queries/3155-how-do-i-count-amount-text-column-then-add-them.html)

Peter Curtis

How do I count the amount of text in a column and then add them

For example I would like to count the number of Mondays inserted into a
column and then sub total.

Thanks

Aladin Akyurek

=COUNTIF(A:A,"Monday")

Peter Curtis wrote:
For example I would like to count the number of Mondays inserted into a
column and then sub total.

Thanks

All times are GMT +1. The time now is 05:50 AM.