Counting Number of Boxes Checked in a Single Row
Hi all!
I am wondering if there is a way to count the number of times a box has been checked in a single cell. For example, I have a row that shows the years that an employee participated in a program (20152022). You can select multiple because they can stay in this program for many years. Then I would want a formula to count how many times they were in the program from that single cell of checked boxed. So if I checked that they were in the program 2019, 2020, 2021, 2022  I would want the formula to show that the total number of years that they participated was 4 years.
Does anyone know if that is possible or have tried it for themselves? TIA!
Best Answer

Nevermind, I was going to delete this but figured i could leave the very simple answer in case others are looking. :)
You can use a simple COUNTM on the column to display the results. So in the column that you want to total displayed you would input =COUNTM([Year Participated]@row). Thanks all!
Answers

Nevermind, I was going to delete this but figured i could leave the very simple answer in case others are looking. :)
You can use a simple COUNTM on the column to display the results. So in the column that you want to total displayed you would input =COUNTM([Year Participated]@row). Thanks all!

Hey @JayCee
Thanks so much for coming back and posting your solution! I'm glad you found the right function for what you needed. 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!