DrPhil
Outstanding Member
I have a check list detailing staff attendance at annual conferences over the past 11 years.
I want a tally at the side to quickly show the boss how many conferences each person has attended.
Each person has a tick (windings font) showing if they attended.
I want excel to count the ticks. It shouldn't be so hard, but I have used every variation of count functions to match the ticks, or COUNTA to just count the boxes that aren't blank, and it won't give me the right figure. For some bizarre reason it gives me 9 every time. Even if I go back and add or remove ticks, it's still 9. Out of a range of 11 cells.
I'd prefer it to count cells containing anything, as the boss is likely to update the table at some stage but use a Y instead of a tick etc.
I want a tally at the side to quickly show the boss how many conferences each person has attended.
Each person has a tick (windings font) showing if they attended.
I want excel to count the ticks. It shouldn't be so hard, but I have used every variation of count functions to match the ticks, or COUNTA to just count the boxes that aren't blank, and it won't give me the right figure. For some bizarre reason it gives me 9 every time. Even if I go back and add or remove ticks, it's still 9. Out of a range of 11 cells.
I'd prefer it to count cells containing anything, as the boss is likely to update the table at some stage but use a Y instead of a tick etc.