use the quick analysis button to sum the range in excel

We could use this named range in our current example. If you are unsure of how to setup a named range in your spreadsheet, read our tutorial on Adding a Named Range.įor example, if we created a named range called years in our spreadsheet that refers to cells A2:A6 in Sheet1 (Notice that the named range is an absolute reference that refers to =Sheet1!$A$2:$A$6 in the image below): A named range is a descriptive name for a collection of cells or range in a worksheet.

You can also use a named range in the SUMIF function. For every value in A2:A6 that matches D2, the corresponding value in C2:C6 will be summed. In this example, the third parameter is C2:C6. The third parameter in the SUMIF function is the range of numbers that will potentially be added together. The SUMIF function will test each value in A2:A6 to see if it is equal to 2000. This is a reference to the cell D2 which contains the numeric value, 2000. In this example, the second parameter is D2.

The second parameter in the SUMIF function is the criteria that will be applied against the range, A2:A6. This is the range of cells that will be tested to determine if they meet the criteria. In this example, the first parameter is A2:A6.

The first parameter in the SUMIF function is the range of cells that you want to apply the criteria against. Now, let's look at the example =SUMIF(A2:A6, D2, C2:C6) that returns a value of 218.6 and take a closer look why. Result: 31.2 'Adds values in C2:C6 that are less than 100 (3rd parameter is omitted) Result: 12.6 'Criteria is greater than or equal to 2001 Result: 218.6 'Criteria applies to all of column A (ie: A:A) Result: 218.6 'Criteria is the value in cell D2 Let's explore how to use SUMIF as a worksheet function in Microsoft Excel.īased on the Excel spreadsheet above, the following SUMIF examples would return: =SUMIF(A2:A6, D2, C2:C6)

Use the quick analysis button to sum the range in excel