I have a row of numbers and those in columns C through F are added together in G. I want H to be a checkbox that is TRUE if the SUM in G is greater than 29. I think I use the SUMIF formula but couldn't figure out the Checkbox part. Thanks for your help and patience with this beginner question!

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Jan 7, 2020 at 17:38

1 Answer 1


Assuming your data are from G4 to G17

3 Steps

  1. Click on cell H4 and place the following formula:


You will get a list of FALSE, TRUE depending on your G column values.

  1. Select the cells H4:H17
  2. Go to top menu Insert > Tickbox

change Checkbox to TRUE depending on another cell's value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.