How to Use SUMIF Function in Google Sheets

[ad_1]

Calculations

Google Sheets has greater than 400 features, together with the helpful SUMIF perform, which you need to use for superior calculations. Here’s how to use it.

Google Sheets consists of quite a lot of highly effective features. These features enable you to create formulation that you need to use to manipulate information or calculate values in your spreadsheet.

One of essentially the most helpful features is SUMIF. Similar to the essential SUM perform, this enables you to discover the overall of a set of values. What makes SUMIF completely different is that it’s going to solely embrace values that meet a particular criterion that you simply set.

If you need to know the way to use the SUMIF perform in Google Sheets, observe our information beneath.

What is the SUMIF Function in Google Sheets?

The SUMIF perform in Google Sheets is an easy however efficient perform that enables you to sum a number of cells out of your information, offered that they meet a particular criterion.

For instance, if in case you have a listing of gross sales figures, and also you needed to know the way a lot cash you’d constructed from increased ticket objects, you may use this perform to sum the overall worth of gross sales from objects that price $500 or extra.

The syntax of the components is as follows:

SUMIF(vary, criterion, [sum_range])

The vary is the collection of cells that you really want the perform to look at. The criterion is the situation {that a} cell should meet for its worth to be included in the sum. The sum vary is in sq. brackets, indicating that that is an optionally available argument that doesn’t want to be included in the perform.

You can use the sum vary if you would like to sum the values from a distinct column. For instance, as an alternative of summing the worth of things that price greater than $500, you possibly can sum the column that holds the variety of gross sales, to learn the way many objects above this worth you’ve bought.

How to Use the SUMIF Function in Google Sheets Within the Given Range

If you need to sum the values inside your given vary, you’ll solely want to enter two values into your perform.

Here’s how to use the SUMIF perform inside your given vary:

  1. Click in the cell the place you need the perform to seem.
  2. Type =SUMIF( and also you’ll see the perform info seem beneath the cell.
    google sheets enter function
  3. You can click on on the down arrow for extra details about how the perform works.
    google sheets function info
  4. Select the cells that you really want the perform to apply to (or sort the cell vary manually).
    select range in google sheets
  5. Click again into your perform and kind a comma.
    insert comma google sheets
  6. Enter your criterion in quotes, adopted by a closed bracket. Your criterion might be a worth, textual content, a logical expression, and even one other perform.
    enter criterion in google sheets
  7. Hit Enter and your perform will calculate, with the output exhibiting in the cell.
    function result in google sheets

In this instance, the perform has discovered the entire objects that had been bought for greater than $500 and located the overall of all these gross sales.

How to Use the SUMIF Function in Google Sheets With a Different Range

Sometimes it’s your decision to seek for values that meet a particular criterion however then need to sum different values from the identical row. For instance, for all gross sales over $500, you may want to sum the overall variety of merchandise bought, relatively than their sale worth.

Here’s how to use the SUMIF perform with a distinct vary:

  1. Click in the cell the place you need the perform to seem.
  2. Type =SUMIF( and also you’ll see the perform info seem beneath the cell.
    google sheets enter function
  3. Now spotlight the cells that you really want the perform to apply to.
    select values in google sheets
  4. Click again into your perform, and kind a comma.
    type a comma in google sheets
  5. Enter your criterion in quotes and kind one other comma.
    type comma in google sheets function
  6. Select the cells that you really want to sum (or sort the vary in manually).
    select sum range in google sheets
  7. Type a ultimate closed bracket and hit Enter.
    add bracket in google sheets
  8. Your perform will now calculate, with the output exhibiting in the cell.
    final result in google sheets

Make the Most of Google Sheets Functions

Google Sheets has nearly 500 completely different features, protecting every part from statistics to textual content manipulation. The extra features you realize about, the extra highly effective Google Sheets turns into.

Google Sheets IF statements are an efficient manner to add a number of standards to your features. The SORT perform permits you to alphabetize your Google Sheets information. You may even use a perform (GOOGLEFINANCE) to observe shares in Google Sheets.

[ad_2]