Business Tools Blog

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.