Opening the SUMIFS Function dialog box
For help with these instructions, see the image above.
- Click on cell F12 to make it the active cell. This is where we will enter the SUMIFS function.
- Click on the Formulas tab.
- Click on the Math & Trig icon on the ribbon to open the function drop down list.
- Click on SUMIFS in the list to bring up the SUMIFS function's dialog box.
These arguments tell the function what conditions we are testing for and what range of data to sum when those conditions are met.