Paul Wherly

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

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.

Shelley Fishel

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

excel-2013-core-part-ii (1)

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.

3 thoughts on “How to use the SUMIF Function in Microsoft Excel 2013

    When clients pay me, I can put all the information in one column and let the spreadsheet filter the payments. Think of filtering checkbook entries.

    I can also filter how they pay, which is important to my business.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More