Here’s a featured picture:
For those who’re working with a spreadsheet in Google Sheets that incorporates checkboxes, you should use the SUMIF perform to sum the values in a variety of cells if the corresponding checkboxes are checked. This may be helpful for shortly calculating totals or averages for particular subsets of knowledge. For instance, you possibly 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 just need to test.
- standards is the standards that you just need to use to find out which cells to sum. This is usually a textual content string, a quantity, or a logical worth.
- sum_range is the vary of cells that you just need to sum. This may be the identical vary because the vary parameter, or it may be a unique 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)
You can even use the SUMIF perform to sum the values in a variety of cells if the corresponding checkboxes are unchecked. To do that, you’ll use the next formulation:
=SUMIF(B2:B10, FALSE, A2:A10)
Creating the SUMIF Components
The SUMIF formulation in Google Sheets permits you to sum values in a variety primarily based on a particular criterion. To make use of SUMIF to sum values the place a checkbox is checked, observe these steps:
- Choose the vary of cells you need to sum. This vary ought to embrace the checkbox column and the values you need to sum.
- Create the SUMIF formulation. The overall syntax of the SUMIF formulation is:
=SUMIF(vary, criterion, sum_range)
The place:
- vary is the vary of cells you need to test for the criterion.
- criterion is the situation you need to meet. On this case, it is going to 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’ll 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 strong spreadsheet program that can be utilized for quite a lot of duties, together with information evaluation and monetary planning. Some of the helpful options of Google Sheets is the power to make use of formulation to carry out advanced calculations. Some of the widespread formulation utilized in Google Sheets is the SUMIF perform, which can be utilized to sum values in a variety 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)
You can even use the SUMIF perform to sum values in a variety of cells if the worth within the corresponding cell within the vary of checkboxes is checked. To do that, you will have 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)
Individuals Additionally Ask About Google Sheets How To Sumif Checkbox Is Checked
How do I test if a checkbox is checked in Google Sheets?
You should utilize the ISCHECKBOX perform to test 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 variety of cells if a checkbox is checked in Google Sheets?
You should utilize the SUMIF perform to sum values in a variety of cells if the corresponding cell within the vary of checkboxes is checked. To do that, you will have 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)
