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!
Google Sheets – Checkbox=TRUE if SUM of Cells Exceeds Value
google sheets
Related Topic
- Google-sheets – How to get sum of largest numbers in each individual row in Google Sheets
- Google-sheets – How to create a formula in Google Sheets that can sum specific cells based on multiple criteria
- Google Sheets – How to Use Text from a Cell in SUMIF
- Google Sheets – Troubleshooting SUMIF Problems
- Google Sheets – Sum Row Values Based on Column Criteria
- Google-sheets – How to count the amount of non-blank cells in a row, including only cells that are in a column that contains a specific value
- Google-sheets – How to add data in a specific row after searching a column for a specific keyword
Best Answer
Assuming your data are from
G4
toG17
3 Steps
H4
and place the following formula:You will get a list of
FALSE
,TRUE
depending on yourG
column values.H4:H17
Insert
>Tickbox