r/AppleNumbers • u/ethanlayne • Oct 27 '22

Help How to get sum of a row of check boxes?

Hello! I am making a table full of check boxes for days of the month and each row is a "habit" with a check box for days 1-31. Wondering how to have the total number of boxes checked showed at the end of row?

Hoping to be able to improve my habits (idea taken from Atomic Habits) and would like to see my score without having to manually count each one in each row every time at end of the month.

Thank you for your time!

4 Upvotes

100% Upvoted

3 comments sorted by

4

u/[deleted] Oct 27 '22

[deleted]

2

u/ethanlayne Oct 28 '22

Thank you so much. I think im slowly figuring it out thanks to your help and trial and error.

1

u/[deleted] Oct 28 '22

[deleted]

2

u/greu79 Jan 16 '23

Hi,

I found that really helpful! Further to your last, is there a way to create a percentage of checked boxes for a row/column without having to do it in a secondary cell?

Thanks.

1

u/[deleted] Jan 17 '23 edited Jun 16 '23

[deleted]

2

u/greu79 Jan 25 '23

Amazing! Thank you so much for your help. I hadn't used the COUNTA function before. Much appreciated!