2 Easy Ways to SUMIF Checkbox Is Checked in Google Sheets

SUMIF Checkbox Is Checked in Google Sheets

Here’s a featured picture: $title$

If you happen to’re working with a spreadsheet in Google Sheets that accommodates checkboxes, you need to 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 overall 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 wish to verify.
standards is the factors that you simply wish 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 wish to sum. This may be the identical vary because the vary parameter, or it may be a unique vary.

For instance, the next components 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 components:

=SUMIF(B2:B10, FALSE, A2:A10)

Creating the SUMIF Formulation

The SUMIF components in Google Sheets lets you 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, comply with these steps:

Choose the vary of cells you wish to sum. This vary ought to embody the checkbox column and the values you wish to sum.
Create the SUMIF components. The final syntax of the SUMIF components is:

=SUMIF(vary, criterion, sum_range)

The place:

vary is the vary of cells you wish to verify for the criterion.
criterion is the situation you wish to meet. On this case, it will likely be a checkbox that’s checked.
sum_range is the vary of cells you wish to sum if the criterion is met.

Enter the components right into a cell. For instance, in case your checkbox column is in column A and the values you wish to sum are in column B, you’ll enter the next components right into a cell:

=SUMIF(A:A, TRUE, B:B)

This components 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 components 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 knowledge evaluation and monetary planning. One of the vital helpful options of Google Sheets is the flexibility to make use of formulation to carry out advanced calculations. One of the vital 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 components 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’ll need 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 components 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 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 components 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 need to use 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’ll need to make use of the ISCHECKBOX perform.