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?
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.
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.