Using various SUM formats
Using SUM( )
The sum function adds values based on a selected range. Example A, shows the total from cells E6 to E9. The syntax is shown as =SUM(E6:E9). You can achieve the same by adding each value individually, like =E6+E7+E8+E9. However, when the list consists of various hundred or thousand values, adding individually becomes inefficient. Therefore, use functions so your work on spreadsheets become more efficient.
Using SUMIF( )
The sumif function combines the sum and the if function. This will add, based on a criteria. Example B, shows the total from cells E6 to E9, but the criteria states number equal or greater than $5,000. For your convenience, I have included the formula next to the result. Please note, three values entered, first the whole range, second the criteria inside quotation marks, and third (this one optional) the sum range if different from the whole range. I like to include the third criteria, so if I need to use a different range, I do not forget its use.
Using SUMIFS( )
The most versatile function, the sumifs allows to add values based on different criterias. Therefore, your formulas become more intelligent, because you can segregate, disect and analyze different types of information within your data. I have included two examples (C and D), first the function looks for females “F”, that earns less than $4,000; the result one, total $3,000. The second, looks for the city “Miami”, that earns less than $4,000; the result none, total $0. This function allows entering various ranges and criteria based on your data; therefore, you can add as many conditions to test and analyze.
Conclusion:
Your spreadsheets should include as many functions and formulas, as possible; this allows your work to be efficient and automated. These functions calculate several different forms of additions and serve as one of the basic components of almost any table that consits of detail and summary figures. Please explore more with these functions, you will not regret it, since they will make your life easier and more productive.