HOW TO WRITE THE SUM FUNCTION IN EXCEL IN THE CORRECT FORMAT
=SUM(A1:A10) – USING A RANGE OF NUMBERS
=SUM(A1+A2+A3) – USING INDIVIDUAL CELLS
=SUM(10+3+4) – USING THE NUMBERS THEMSELVES
EXAMPLE
THE INPUT FOR A FORMULA OR FUNCTION SHOULD BE EITHER:
- A SET OF NUMBER OR
- A REFERENCE TO THE CELL(S)
EXAMPLE
THE SUM( ) FUNCTION CAN BE USED IN MULTIPLE WAYS:
=SUM(A1+B1+C1)
=SUM(2+3+4)
=SUM(A3:C3)
=A3+B3+C3
No Comments