1. SUMIF
  2. VLOOKUPS for more than 10K rows
  3. a calculator to check your work because...sometimes that can't possibly be the right answer