Excel SUMIFS Function Step by Step Tutorial

By Ted French, About.com Guide

Opening the SUMIFS Function dialog box

Although it is possible to just type the SUMIFS function into a cell in a worksheet, many people find it easier to use the function's dialog box to enter the function.

Tutorial Steps

For help with these instructions, see the image above.

1. Click on cell F12 to make it the active cell. This is where we will enter the SUMIFS function.


2. Click on the Formulas tab.


3. Click on the Math & Trig icon on the ribbon to open the function drop down list.


4. Click on SUMIFS in the list to bring up the SUMIFS function's dialog box.

The data that we enter into the blank lines in the dialog box will form the arguments of the SUMIFS function.

These arguments tell the function what conditions we are testing for and what range of data to sum when those conditions are met.