summing a column of "x"'s

[jonty]

Hallo , I hope someone can help - I thoguht i could figure this one out myself but can't get it.

I have a column with about 30 rows to it.
In some of the rows i have placed an x in the row.
I need a formula to do a count of all the rows where there is an "x"
I thought of sum(subsitute((b1..b30),"x",1)) but it doesn't seem to work

Thanks

 

[Aladin Akyurek]

On 2002-04-28 22:37, jonty wrote:
Hallo , I hope someone can help - I thoguht i could figure this one out myself but can't get it.

I have a column with about 30 rows to it.
In some of the rows i have placed an x in the row.
I need a formula to do a count of all the rows where there is an "x"
I thought of sum(subsitute((b1..b30),"x",1)) but it doesn't seem to work

Thanks

=COUNTIF(B1:B30,"X")

will suffice.

 

[jonty]

- Derrrrr !!
brain a bit fried after only 1 days work.

thanks