Adding Many Totals

donnajay

New Member
Joined
Jul 30, 2009
Messages
36
I have a spreadsheet that has many numbers and then totals. The spreadsheet consists of 1600 rows (not all totals!):eek:

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.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
What is the difference that triggers a Total. Change in some ID#, Date, something else?

lenze
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi

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

=SUM(A2:A1000)/2
 

Watch MrExcel Video

Forum statistics

Threads
1,130,119
Messages
5,640,218
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top