mardi 17 décembre 2019

Google Sheets For each checkbox true add 8 hours

I have created a column of checkboxes and underneath I have a total box, where if a box is checked I want to add 8 to the total box, I have tried a few ways but am at a loss. My Current formula is as follow:

=QUERY(K3:K9,"where K = 0",1+8)

This, however, is only returning the True or false option. when all I'm trying to do is make it return a +8

Example

2 boxes checked that cell shows 16

5 boxes checked that cell shows 40

Preview

You can see what I am working on at this link and feel free to help with anything you want I do have it backed up and am struggling a lot with this. I will return at 2 am EST

My Sheet

Aucun commentaire:

Enregistrer un commentaire