ExcelBanter - how do I add a list of numbers to get a total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I add a list of numbers to get a total (https://www.excelbanter.com/excel-discussion-misc-queries/668-how-do-i-add-list-numbers-get-total.html)

bibs

how do I add a list of numbers to get a total

tjtjjtjt

If your numbers are in cells A1 through A10, try:
=SUM(A1:A10)

If you have something more complex in mind, please post an example.

tj

"bibs" wrote:

Biff

Hi!

If your list is in the range A1:A25:

=SUM(A1:A25)

Biff

All times are GMT +1. The time now is 06:12 AM.