ExcelBanter - x = 1 or a value

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

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

- - x = 1 or a value (https://www.excelbanter.com/excel-worksheet-functions/219300-x-%3D-1-value.html)

gma

x = 1 or a value

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

Mike H

x = 1 or a value

Try

=COUNTIF(A1:A27,"x")

Mike

"gma" wrote:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

Stefi

x = 1 or a value

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

€žgma€ ezt Ã*rta:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

gma

x = 1 or a value

thanks

"Stefi" wrote:

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

€žgma€ ezt Ã*rta:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

gma

x = 1 or a value

thanks mike

"Mike H" wrote:

Try

=COUNTIF(A1:A27,"x")

Mike

"gma" wrote:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

Stefi

x = 1 or a value

You are welcome! Thanks for the feedback!
Stefi

€žgma€ ezt Ã*rta:

thanks

"Stefi" wrote:

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

€žgma€ ezt Ã*rta:

I want to put a "X" in a cell and had that total a number
colume a
1 X
2 X
3 X
total 3

how do i do that or can it be done?

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