How to use the SUMIF Function in Microsoft Excel 2013

How to use the SUMIF Function in Microsoft Excel 2013

This function will add the value of cells that meet a certain criteria.

For example, suppose we want to calculate the total salary cost of all females:

Figure – Sumif adds up all the rows that meet your criteria

If the range B2 to B7 says Female then add up all of the salaries that correspond.

The answer for the Total Female Salaries = £79,000.

The syntax for the SUMIF function is as follows:

The structure of a SUMIF Function

=SUMIF(Range,Criteria,Sum Range)

 Range:                         The range of cells that Excel is to look at

 Criteria:                      The criteria that the cells must meet in order to be added

 Sum Range:                 The cells to Sum

Has this tip helped you? Let me know how by leaving a comment.

This topic has been taken from my free eBook on Microsoft Excel Core: Advanced 2013 which can be downloaded here:

To find out more about our training and to discuss your organisation’s learning needs, give us a call on 020 8203 1774 or email us enquiries@theittrainingsurgery.com – we would love to chat.