+ Reply to Thread
Results 1 to 3 of 3

Google Sheets Checkbox SUM Help

  1. #1
    Forum Contributor
    Join Date
    08-08-2019
    Location
    CO
    MS-Off Ver
    Office 365
    Posts
    106

    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.

    https://docs.google.com/spreadsheets...gid=1145922216

    Thanks in advance!

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheets Checkbox SUM Help

    You could simplify things by
    * clicking into the cell around the checkbox in G1,
    * removing the FALSE value
    * using this formula instead:
    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.
    Last edited by janmorris; 11-24-2022 at 08:15 AM.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Forum Contributor
    Join Date
    08-08-2019
    Location
    CO
    MS-Off Ver
    Office 365
    Posts
    106

    Re: Google Sheets Checkbox SUM Help

    This worked perfectly! Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google SHeets: Count Checked checkboxes in filtered data of google sheet
    By Faizan Naseem in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-07-2022, 05:42 AM
  2. Google Sheets formula for bringing in checkbox info from sheet B to sheet A
    By wolverineandrew in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-14-2022, 08:00 AM
  3. Replies: 0
    Last Post: 02-13-2022, 05:51 PM
  4. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  5. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  6. [SOLVED] Google Sheets: IF Formula on Checkbox
    By zainmerchant in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 25
    Last Post: 01-02-2021, 07:11 AM
  7. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM

Bookmarks

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