Google Sheets - counting checkboxes

[remalguy]

Hello guys,
I need help in counting names with checkboxes near them

checkbox count

docs.google.com

In the example, I try to count how many names were absent in a given list

thanks in advance

 

[dwang]

Are you open to a different structure for your spreadsheet? If you create a master record sheet and a "data entry" sheet that records who's present, you could much more easily generate a report of how many absences someone has by. It's hard for Google Sheets to count checkboxes, especially when the data is spread out into multiple columns and rows per event like that.
Let me know if you're interested; I can send over a sample.

 

[remalguy]

Are you open to a different structure for your spreadsheet? If you create a master record sheet and a "data entry" sheet that records who's present, you could much more easily generate a report of how many absences someone has by. It's hard for Google Sheets to count checkboxes, especially when the data is spread out into multiple columns and rows per event like that.
Let me know if you're interested; I can send over a sample.

First of all, thanks a lot for your time :D
Yes, maybe I can use another structure. If you can send this sample it will help a lot.

Cheers

 

[dwang]

Something like this:

Sample Attendance

docs.google.com

Definitely not as elegant as it could be, and the formula on Statistics could be more elegant, but it works.

 

[remalguy]

Many thanks for your efforts....I'll work with this approach :D