1. Google Sheets Checkbox SUM Help

Hello everyone,

I am looking for a formula to sum if either of 2 checkboxes are true to subtract several columns for a total. What I need to achieve is if a box is checked it will basically think it's either an 8-hour workday or a 10-hour workday. Hopefully, the formula below explains better what I am after:

Within Cell F28:

``Please Login or Register  to view this content.``
A bit of context behind what I am trying to achieve. A technician has 5 potential jobs in a day. Each job could take a different amount of time. Some weeks are 8-hour days and some are 10-hour days. I need to be able to add in the amount of time each job takes (in the G cells), then depending on what cell is check-marked (E1 or G1), return how many hours are left to block out for the tech.

I am sharing the link so hopefully, it can be understood a bit better.

I apologize if I am posting this on the wrong board. I could not find a specific place for a google sheet question. I assume the formulas would be similar.

2. Re: Google Sheets Checkbox SUM Help

You could simplify things by
* clicking into the cell around the checkbox in G1,
* removing the FALSE value
``Please Login or Register  to view this content.``
* putting this formula into F28:
``Please Login or Register  to view this content.``
Making the change to G1 will make it automatic, you only need to check E1, or uncheck E1, you do not need to touch G1 because the formula makes it automatic switching.

IF you cant get this working, then you should give Editor rights to your file so we can work directly with the sample.

3. Re: Google Sheets Checkbox SUM Help

This worked perfectly! Thank you very much!

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1