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

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
Aucun commentaire:
Enregistrer un commentaire