x = 1 or a value

[gma]

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]

Try

=COUNTIF(A1:A27,"x")

Mike

 

[Stefi]

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

„gma†ezt írta:

 

[gma]

thanks

Insert this formula in the required result cell:

=COUNTIF(A1:A3,"X")

Adjust range as needed!

Regards,
Stefi

„gma†ezt írta:

 

[gma]

thanks mike

Try

=COUNTIF(A1:A27,"x")

Mike

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„gma†ezt írta: