Google Sheets – Checkbox=TRUE if SUM of Cells Exceeds Value

google sheets

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!

Best Answer

Assuming your data are from G4 to G17

3 Steps

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

=ArrayFormula(IF(G4:G17>20,TRUE,FALSE))

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