Quote:
Originally Posted by nkanaga
Could some one please let me know how to sum the below number. The below numbers are in the same draw and coulmn.
5+9+3+8+1+6
|
If the numbers are in A1, A2, A3, A4, A5, and A6 respectively, then the following formulas would work in A7.
=A1+A2+A3+A4+A5+A6
or
=SUM(A1:A6)