This one is for you Fritz.
Excel’s SUMIF function, automates long formulas, by summing all rows with the same criteria.
Example - the old way to sum the SG&A totals would be to type =c27+c17+c10
The Sumif forumla adds all numbers in a range of cells, based on a given criteria. =Sumif(A10:A27,A29,C10:C27)
- I put a “t” in column A for each rown with a total
- A10:A27 is the range that has the criteria that we want to Sum
- A29=”t”. This is the criteria used to determine which cells to Sum
- C10:C27 is the range of cells that will be summed, if there is a “t” in their row
- The result is that the formula adds rows 10, 17 and 27
This formula is great if you are changing criteria or if you have to sum totals in a very a large spreadsheet.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare