Summary: This video tutorial shows you how to sum specific cells using the SumIf formula in Microsoft Excel with an example that is easy to follow. http://youtu.be/iXvwToRY7Qo The SumIf function in Excel is something that I use quite often when I want to add cell values based upon specific criteria. The syntax for the SumIf function is: Where "Range" is the cells that the SumIf function searches, "Criteria" is the statement that the SumIf function evaluates in the range to determine if a specific cell should be summed, and "Sum Range" is the cells that the SumIf function adds when the specified criteria evaluates as true in a specific cell. *If the "Sum Range" is omitted from the formula, then the cells in the "Range" are added if the specified criteria evaluates as true in a specific cell. Example: A B C 1 Sales Dept Criteria 2 100 Software software 3 120 Hardware hardware 4 90 Hardware accessories 5 15 Accessories 6 45 Accessories 7 200 Software 8 60 Accessories In this example we could do the formula =SUMIF(B2:B8, C2, A2:A8) The formula would search in the range B2:B8 and evaluate if any of the cells match the criteria in C2. If a cell in B2:B8 has the same value as in cell C2, then the formula adds the corresponding cell value in the A column to the total. In this example the sum of the formula would be 300 because "software" only appears in cells B2 and B7, which when adding A2 and A7 together, it equals 300.
