How can you count three seperate 'things' in one column?

  • Thread starter Thread starter gloriousglenn
  • Start date Start date
G

gloriousglenn

Hi all,

I have a spreadsheet column where each cell will either have 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
 
Input this into cell that you want to count ticks:
=COUNTIF(A1:A35," ")
If the tick sign included in this formula differs from the one you
have, you need to copy and paste from your cells to this formula. Also
this formula searches cells in column A, from row 1 to row 35. Please
adjust to your range.

Same apply for the cell that you want to count crosses:
=COUNTIF(A1:A35,"†")

And finally, for the cells to count blanks, input:
=COUNTIF(A1:A35,"")

http://www.exciter.gr
Custom Excel Applications and Functions!
 
Hi all,

I have a spreadsheet column where each cell will either have 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
Click to expand...

See response to your identical question posted three minutes before this one.
--ron
 
Back
Top