Cell Formulas: Part 1

Cell Formulas: Part 2

Takeaways:

• Formula for summing up cell values:
  • = (first cell) + (second cell) + (third cell) + etc.
  • Example: = A1 + H9
  • You can add up however many cells you want


• Formula for subtracting cell values:
  • = (first cell) - (second cell) - (third cell) + etc.
  • Example: = A1 - H9
  • You can also add AND subtract values: = A1 - H9 +E3


• Adding multiple values in a column:
  • = sum(top cell : bottom cell)
  • A shortcut to add C5, C6, C7, C8, C9, and C10 is: = sum(C5:C10)