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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gloriousglenn@hotmail.com - 02 Nov 2007 11:57 GMT

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

Reply to this Message

www.exciter.gr: Custom Excel Applications! - 02 Nov 2007 12:30 GMT

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!

On Nov 2, 12:57 pm, gloriousgl...@hotmail.com wrote:

> Hi all,
>
[quoted text clipped - 8 lines]
> Cheers
> Glenn

Reply to this Message

Ron Rosenfeld - 02 Nov 2007 12:35 GMT

>Hi all,
>
[quoted text clipped - 8 lines]
>Cheers
>Glenn

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

Reply to this Message

Rate this thread: