DJH Training & Application Solutions | Excel SumIf Function
Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

MICROSOFT EXCEL SUMIF FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use SUMIF to conditionally sum a range of values, based on a single criterion

Would you like the most current sales figure for a certain product? Or perhaps the quantity on hand of an item? SUMIF makes it a snap!

In the example below, we sum the employee salaries by department.

 

Step 1. Set up your data correctly, preferably converting it to a table

 

Step 2. Add the SUMIF formula the the Salaries column to arrive at the results below

 

DETAILED EXPLANATION

SYNTAX: =SUMIF(Range in which Criteria is found ,Criteria, Sum Range if different from Range)

 

EXAMPLE 1: Formula example if referring to a table range (tables are preferable, as will expand/contract as add/remove data):

=SUMIF(tblEmployeeData[Department],[@Department],tblEmployeeData[Salary])

 

EXAMPLE 2: Formula example if referring to a regular data range:

=SUMIF($D$4:$D$22,E27,$F$4:$F$22)

 

 

 

 

 

 



More Newsletter Articles

© 2018 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.