How do I count three different things in one column?

[gloriousglenn]

Hi all,

I have a spreadsheet where a column will have either a tick, a cross
or is left blank. How can I setup three cells to show how many ticks,
crosses and blanks there are in the column?

I hope this is clear as what I am trying to do.

Cheers
Glenn

 

[Ron Rosenfeld]

Hi all,

I have a spreadsheet where a column will have either a tick, a cross
or is left blank. How can I setup three cells to show how many ticks,
crosses and blanks there are in the column?

I hope this is clear as what I am trying to do.

Cheers
Glenn

Use COUNTIF

cross:

=COUNTIF(rng,"x")

tick:

=COUNTIF(rng,"'")

blank:

=COUNTIF(rng,"")

The above assumes that ONLY the cross or tick are in the cell. If there might
be other cell contents, then you can use wildcards.


--ron