Excel SUMIF Function

3/24/2018

The Microsoft Excel SUMIFS function lets you specify multiple IF conditions within one formula and add together cells based on the conditions.

It can be used to evaluate if multiple conditions are true do this, but if they are false do this. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value. Syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) Sum Range is the range of cells you want to add together. The criteria range is the range(s) you want to evaluate with the criteria being the condition.

0 Comments

Computer tips that will increase productivity and your overall computer experience.

These helpful tips can make a big difference in your workflow—and save you tons of time in the process.
You may be wondering whether shortcuts really help…they do. If you become proficient with 3 or 4 common shortcuts, you will save time.
New tips added weekly

Author

With over 25 years in the computer industry, JoLynn Rihn has been helping people to become more efficient and effective with their computer software. She offers tips on using the latest programs so that using a computer can be more easy and fun to use.