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.
Thanks,
I can use this function.
Gary
Nice to hear – what will you use it for?
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.