count ticks in boxes

[Adrian]

I am using excel 2003. I have put a column of about 20 tick boxes into a
spreadsheet. I want a cell at the bottom of the column of tick boxes to count
the number of ticks I have put into the individual boxes eg. if I tick 15
boxes I want the cell at the bottom to display 15. Any Ideas?

[robert111]

I tried this and countif(a1:a10,"v") works

Naturally, the v is meant to be the tick symbol, you can give the cell reference of the cell in your list that contains a tick.

[Dave Peterson]

Are tick boxes the same thing as checkboxes (like from the control toolbox
toolbar or the Forms toolbar)?

If yes, you can assign each checkbox its own linked cell in the same row and
then count the number of True's in that range:

=countif(a2:a21,TRUE)



Adrian wrote:
>
> I am using excel 2003. I have put a column of about 20 tick boxes into a
> spreadsheet. I want a cell at the bottom of the column of tick boxes to count
> the number of ticks I have put into the individual boxes eg. if I tick 15
> boxes I want the cell at the bottom to display 15. Any Ideas?

--

Dave Peterson