Spreadshet formula to add totals

=SUM (Range value)

like = SUM (A1:A7) or = SUM (A1:H1)

Explanation:

We need to make use of the SUM function, and then we need to mention the cells or range value that references a series of cells row-wise or column-wise. Like a range value of A1:A7 means A1, A2, A3, A4, A5, A6, A7 and the range value of A1:H1 means A1, B1, C1, D1, E1, F1, G1, H1. And similarly, you can represent various cells depending upon the code you come up it, and finally, you need to sum them all using the SUM function.