ExcelBanter - How do I add the number of variables?

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

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

- - How do I add the number of variables? (https://www.excelbanter.com/excel-discussion-misc-queries/39325-how-do-i-add-number-variables.html)

emaufmuth

How do I add the number of variables?

I have a column with x 's in cells to indicate whether or not a service was
received. How can I now total the number of x 's to calculate the total
number of clients receiving a service? Any help is appreciated!

Duke Carey

=COUNTIF(A:A,"x")

"emaufmuth" wrote:

I have a column with x 's in cells to indicate whether or not a service was
received. How can I now total the number of x 's to calculate the total
number of clients receiving a service? Any help is appreciated!

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