ACSKNIGHTS
New Member
- Joined
- May 1, 2023
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hello, I am trying to figure out a formula to count True/False check mark boxes in every other column without having to select every other cell in that row. I have multiple rows for a roster of students with enough columns for every school day (roughly 260) on our school calendar where we will be checking boxes according to whether or not the student ate hot lunch (one column) and if they had an extra meal (next column) for each day. I need to keep a running tally of the two separate values for the entire range but they have to be side by side, therefore I need to count every other column. Is there a shorter way to do this other than adding 260 'Countifs' formulas together? Thanks for your feedback!