Adding Many Totals

[donnajay]

I have a spreadsheet that has many numbers and then totals. The spreadsheet consists of 1600 rows (not all totals!)

I tried =sum( then all the cells that had totals) but it says arguement it too large.

Is there a way to just add up the totals cells and not all the numbers that consisted it?

ex: 25.00
25.00
50.00

25.00
25.00
25.00
75.00

and so on.

 

[lenze]

What is the difference that triggers a Total. Change in some ID#, Date, something else?

lenze

 

[pgc01]

Hi

You can simply add all and divide by 2, like:

=SUM(A2:A1000)/2