If you’re looking to easily sum numbers in a range based on specific criteria, then SUMIFS is the perfect function for you. In this tutorial, we’ll take a look at how to use SUMIFS in Google Sheets.
First, let’s take a quick look at the format of the SUMIFS function formula. Essentially, SUMIFS returns the sum of numbers in the specified range based on one or more criteria. The sum range is the range that contains the numbers you want to sum, and the criteria range is the range that contains the criteria you want to use.
Moving forward, let’s take a look at how to use the SUMIFS function in a practical example. Let’s say we want to get the total quantity ordered and total amount received from dealer id 34483 for product hard disk. Instead of manually typing in this data, we can use a formula to get the same result.
To get the total quantity, we start by typing “=SUMIFS” into the cell where we want the result. Then, we select the sum range (the range we want to sum), the criteria range 1 (the first criteria range), the criterion 1 (the first criterion), the criteria range 2 (the second criteria range), and the criterion 2 (the second criterion). Finally, we press enter to get the result.
To get the total order value, we can simply copy the formula we just created and make two changes. First, we make the address of the sum range absolute so it doesn’t change when we copy the formula. Second, we change the sum range to the range that contains the total amount. After making these changes, we can copy the formula to the desired cell and get the total sales amount for the product.
That’s it! With just a few simple steps, we can easily use the SUMIFS function in Google Sheets to get the results we need.