• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 5. Working with Formulas and Functi... > Adding a Range Given Criteria (SUMIF...

Adding a Range Given Criteria (SUMIF)

Click in the cell in which you want the result of the function to appear (this is called the resultant cell).

Click the down arrow next to the AutoSum button on the Standard toolbar and choose More Functions from the list that appears.

The Insert Function dialog box opens. Click the down arrow next to the Or select a category field and choose Math & Trig from the list that appears.

A list of math and trig functions appears in the Select a function list. Scroll through the list to locate the SUMIF function, and double-click it.

INTRODUCTION

Using Excel, you can add the data in range, given certain criteria. This might be useful if, say, you needed to total the current monthly sales for all sales reps who match a specific criterion—for example, who are all in the same sales region.


TIP

Function arguments help

If you need help while you are inputting your function arguments, click the Help on this function link in the bottom-left corner of the Function Arguments dialog box.


In the Range field, type the range of cells whose contents you want to review—for example, C2:C79. (You can also click directly in the worksheet to select the cells.)

In the Criteria field, type the criterion you want to check in the range—in this case, type “1” because you want to add sales data from Region 1 only.

In the Sum_range field, type the range of cells that match your criterion—in this case, F2:F79, which contains the current month sales data. Click OK.

Excel adds the range given your criteria and inserts the result in the resultant cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint