Adding Sums in an Array

jenniesmith

New Member
Joined
Dec 8, 2003
Messages
15
I am looking for an array formula that adds the sums in a range rather than just summing the sum cells. This is in case a sum cell needs to be deleted. Any ideas?
:rolleyes:
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
jenniesmith said:
I am looking for an array formula that adds the sums in a range rather than just summing the sum cells. This is in case a sum cell needs to be deleted. Any ideas?
:rolleyes:

How do you mean? Care to post a very small sample to show what is needed?
 

jenniesmith

New Member
Joined
Dec 8, 2003
Messages
15
Sure. I have several sections within on sheet that have their own sums and I am looking for a way to add the sums together with out just using a =(a1+a5+...). I would like to add the sums in a way that if two of the sections become combined, then the master sum for the sheet would just add each sum rather than look for a reference cell so if I have 3 sums and then I combine two of the sections the master sum equation adjusts to the now two sum cells. Did I make this more confusing?
 

jenniesmith

New Member
Joined
Dec 8, 2003
Messages
15
I think I can name the section, but what how would you state the formula to only then add the sums in the range? Thanks to anyone with advice!
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473

ADVERTISEMENT

? Something like this --
Book1
ABCD
166611
25432
37993
44754
5855
64556
774287
8508
997699
10239910
11784922355
12
13648
14One=A1:A10,Two=B1:C10,Three=D1:D10
Sheet1
 

jenniesmith

New Member
Joined
Dec 8, 2003
Messages
15
Thanks Jon, but it is more like I have sums D1:d:6, d12:d14, d16:d19... and I would like to recognize every cell in column d that has a cell with in a range becuase I have multiple ranges within Column D. The actual situation is that I have several salespeople and several store types. I want to add the several people within several store types on the same page to get a total of salespeople within the store type, then all the store types together. Periodically, salespeople leave and sometimes two sections are combined which would throw off a sum with specific reference cells. I would like to have the formula look within the range for the occurance of formulas that sum within a range so if the number of cells that sum change up or down the total sum would not have to change.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473

ADVERTISEMENT

Is there anything that says when a store-type, by row ? thinking that you might have a cell on each row for such designation. If possible, download and install [new MS MVP!] Colo's utility at the bottom of the page and give us a screenshot for your sheet.
 

Todd Bardoni

Well-known Member
Joined
Aug 29, 2002
Messages
3,042
It almost sounds like you're doing subtotals and want to SUM the result of the subtotals. Is this fair to say?
 

jenniesmith

New Member
Joined
Dec 8, 2003
Messages
15
Yes. I can use a subotal system if there is a way to sum below without having to adjust the sum or formula everytime a subtotal is added or deleted above it. Any thoughts?
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,492
Messages
5,764,686
Members
425,230
Latest member
DzOus

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