ExcelBanter - Counting "X"s in a column

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting "X"s in a column (https://www.excelbanter.com/excel-worksheet-functions/154782-counting-x-s-column.html)

YBeaupre

Counting "X"s in a column

Hi,

Can anyone tell me how to count the numbers of "X" in a column.

Thanks

Elkar

Counting "X"s in a column

Try this:

=COUNTIF(A1:A100,"X")

HTH,
Elkar

"YBeaupre" wrote:

Hi,

Can anyone tell me how to count the numbers of "X" in a column.

Thanks

YBeaupre

Counting "X"s in a column

Hi Elkar,

Many thanks. It does exactly what I wish.

"Elkar" wrote:

Try this:

=COUNTIF(A1:A100,"X")

HTH,
Elkar

"YBeaupre" wrote:

Hi,

Can anyone tell me how to count the numbers of "X" in a column.

Thanks

All times are GMT +1. The time now is 07:00 PM.