Tag: Excel
-
Formula Basics, SumIFS
This function is best for when you have multiple limitations (criteria) you need considered when adding values. Are you feeling like you have a good handle on how SUMIF works? Do you understand the difference between Range and Sum_range? Great, because now we’re going to move things around a bit but maintain the definitions we’ve…
-
Formula Basics, SumIF
Use this formula when you want to add numbers in a range but only if they meet or do not meet certain criteria. That criteria can be text or values. Today we’ll focus on values. Let’s say we have the following table. In this table, we want to determine the total of all salaries paid…
-
Formula Basics, SumIF
We’ve covered how to do sumifs with number limitations. But what if we wanted to see the total of all bonuses paid only to managers, using the data in our spreadsheet? Start by going either to the Home ribbon in the Editing group or to the Formulas ribbon in the Function Library group, clicking the…
-
Formula Basics, Sums
For the next week, I’ll be discussing common formulas and when to apply them focusing on the Sum feature. I chose this simple formula because the basics apply to most of the other common functions. If you simply want to see the end results of the formulas and learn how they work later, skip to…
Ryn Nicol 