How to find product of every other cell

[ACSKNIGHTS]

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!

 

[awoohaw]

@kweaver , sorry but photos are helpful here.
From Developer Tab, insert a check box control.
When the checkbox is drawn, right click and select format control.

assign a cell to it:

checked value is true, unchecked is False

you can tell it how to move/not move.

 

[kweaver]

I know how to insert a check box...LOL. I was asking the OP that nature of his sheet since we can't see it (for some reason).

 

[awoohaw]

@kweaver I don't think where the OP stores the check box result is that important. He wants to count every other column which has been answered in two different ways here, one using the MOD function and another using EVEN function or ODD function. I'm unsure if the OP is satisfied though.

I know how to insert a check box...LOL. I was asking the OP that nature of his sheet since we can't see it (for some reaso

 

[ACSKNIGHTS]

How are the check boxes inserted in the cells? Are they from a Form Control or ActiveX?

Please don't post a photo...use XL2BB.

Well, I actually am modifying a template on google sheets that already had the check boxes in it. Thanks to your question to me, I now know HOW to enter the check boxes!! Thank you! I am definitely an excel 'beginner' when it comes to everything I need to learn about excel. I am very much appreciating all of this help and feedback!

 

[kweaver]

AH, you also never said this was Google Sheets which sometimes behaves differently from Excel.

 

[ACSKNIGHTS]

I think check boxes send values to associated cells, but that mean you need to create a lot of check boxes.

If you do, you just need to know what the checkbox values are and what column they go i

I think check boxes send values to associated cells, but that mean you need to create a lot of check boxes.

If you do, you just need to know what the checkbox values are and what column they go in.

So the check boxes have a value of "true" or "false". When checked, they are true, when empty they are false. I am able to use a COUNIF formula to count them if they return a "true" or "false" value. I wonder if you can enter a value of 0/1 or NO/YES in those cells, and write the desired formula for counting every other column, you should be able to enter True/False for the values. But, there's where I'm stuck. (This is in google sheets, so perhaps this won't even work...?). I'm such a newbie to this, but eager to find the answer!

 

[kweaver]

In playing around with Google Sheets and 0s and 1s, I tried the following. As the columns expand to additional days, you'd have to modify the Q reference accordingly.

 

[awoohaw]

So the check boxes have a value of "true" or "false". When checked, they are true, when empty they are false. I am able to use a COUNIF formula to count them if they return a "true" or "false" value. I wonder if you can enter a value of 0/1 or NO/YES in those cells, and write the desired formula for counting every other column, you should be able to enter True/False for the values. But, there's where I'm stuck. (This is in google sheets, so perhaps this won't even work...?). I'm such a newbie to this, but eager to find the answer!

I'm John Snow when it comes to Google sheets. I know nuthin'.

 

[kweaver]