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
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 firstname.lastname@example.org – we would love to chat.