Counting Number of Boxes Checked in a Single Row

JayCee

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 (2015-2022). 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!

JayCee

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!

JayCee

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!

Genevieve P.

Hey @JayCee

Thanks so much for coming back and posting your solution! I'm glad you found the right function for what you needed. 🙂