Which formula adds the values in cells A1 to A5 in Excel?

  • A =ADD(A1:A5)
  • B =TOTAL(A1,A5)
  • C =PLUS(A1:A5)
  • D =SUM(A1:A5)

Explanation

SUM adds a range of cells. Useful for: NTS, PPSC, FPSC, FIA.