Here’s a featured picture:
In case you’re working with a spreadsheet in Google Sheets that comprises checkboxes, you should use the SUMIF perform to sum the values in a spread of cells if the corresponding checkboxes are checked. This may be helpful for shortly calculating totals or averages for particular subsets of information. For instance, you can use this perform to calculate the full gross sales for all merchandise which can be in inventory, or the common age of all staff who’ve been with the corporate for greater than 5 years.
The syntax for the SUMIF perform is as follows:
=SUMIF(vary, standards, sum_range)
- vary is the vary of cells that you simply need to verify.
- standards is the factors that you simply need to use to find out which cells to sum. This generally is a textual content string, a quantity, or a logical worth.
- sum_range is the vary of cells that you simply need to sum. This may be the identical vary because the vary parameter, or it may be a special vary.
For instance, the next formulation would sum the values within the vary A2:A10 if the corresponding checkboxes within the vary B2:B10 are checked:
=SUMIF(B2:B10, TRUE, A2:A10)
It’s also possible to use the SUMIF perform to sum the values in a spread of cells if the corresponding checkboxes are unchecked. To do that, you’d use the next formulation:
=SUMIF(B2:B10, FALSE, A2:A10)
Creating the SUMIF Formulation
The SUMIF formulation in Google Sheets means that you can sum values in a spread primarily based on a particular criterion. To make use of SUMIF to sum values the place a checkbox is checked, comply with these steps:
- Choose the vary of cells you need to sum. This vary ought to embody the checkbox column and the values you need to sum.
- Create the SUMIF formulation. The final syntax of the SUMIF formulation is:
=SUMIF(vary, criterion, sum_range)
The place:
- vary is the vary of cells you need to verify for the criterion.
- criterion is the situation you need to meet. On this case, will probably be a checkbox that’s checked.
- sum_range is the vary of cells you need to sum if the criterion is met.
- Enter the formulation right into a cell. For instance, in case your checkbox column is in column A and the values you need to sum are in column B, you’d enter the next formulation right into a cell:
=SUMIF(A:A, TRUE, B:B)
This formulation checks the cells in column A for checkboxes which can be checked (TRUE) after which sums the values in column B for these rows.
- Press Enter. The formulation will calculate the sum of the values in column B for the rows the place the checkboxes in column A are checked.
Google Sheets How To Sumif Checkbox Is Checked
Google Sheets is a robust spreadsheet program that can be utilized for quite a lot of duties, together with knowledge evaluation and monetary planning. Some of the helpful options of Google Sheets is the flexibility to make use of formulation to carry out advanced calculations. Some of the frequent formulation utilized in Google Sheets is the SUMIF perform, which can be utilized to sum values in a spread of cells that meet a sure criterion.
For instance, the next formulation would sum the values within the vary A1:A10 if the worth within the corresponding cell within the vary B1:B10 is the same as "Sure":
=SUMIF(B1:B10, "Sure", A1:A10)
It’s also possible to use the SUMIF perform to sum values in a spread of cells if the worth within the corresponding cell within the vary of checkboxes is checked. To do that, you have to to make use of the ISCHECKBOX perform. The ISCHECKBOX perform returns TRUE if the cell is a checkbox and FALSE if it’s not.
For instance, the next formulation would sum the values within the vary A1:A10 if the corresponding cell within the vary B1:B10 is a checkbox that’s checked:
=SUMIF(ISCHECKBOX(B1:B10), TRUE, A1:A10)
Folks Additionally Ask About Google Sheets How To Sumif Checkbox Is Checked
How do I verify if a checkbox is checked in Google Sheets?
You need to use the ISCHECKBOX perform to verify if a cell is a checkbox. The ISCHECKBOX perform returns TRUE if the cell is a checkbox and FALSE if it’s not.
For instance, the next formulation would return TRUE if the cell A1 is a checkbox:
=ISCHECKBOX(A1)
How do I sum values in a spread of cells if a checkbox is checked in Google Sheets?
You need to use the SUMIF perform to sum values in a spread of cells if the corresponding cell within the vary of checkboxes is checked. To do that, you have to to make use of the ISCHECKBOX perform.
For instance, the next formulation would sum the values within the vary A1:A10 if the corresponding cell within the vary B1:B10 is a checkbox that’s checked:
=SUMIF(ISCHECKBOX(B1:B10), TRUE, A1:A10)
