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.

Related Posts Plugin for WordPress, Blogger...
3 Responses to "How to use the SUMIF Function in Microsoft Excel 2013"
  1. Gary Thaller says:

    Thanks,

    I can use this function.

    Gary
    Gary Thaller recently posted…Take the Comma Challenge and Win a Free book!My Profile

  2. Gary Thaller says:

    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.
    Gary Thaller recently posted…Take the Comma Challenge and Win a Free book!My Profile

Leave a Reply

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

CommentLuv badge
 
Textbox Section
 

Terms & Conditions

Welcome to the IT Training Surgery Website. Here are the legal pages for using this site. Please …

Contact us

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