summing a column of "x"'s

jonty · Apr 28th, 2002, 11:37 PM

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 · Apr 28th, 2002, 11:39 PM

Quote:

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 · Apr 28th, 2002, 11:46 PM

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

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 28th, 2002, 11:37 PM	#1
jonty Board Regular Join Date: Mar 2002 Posts: 54	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

Apr 28th, 2002, 11:46 PM	#3
jonty Board Regular Join Date: Mar 2002 Posts: 54	- Derrrrr !! brain a bit fried after only 1 days work. thanks