MrExcel Publishing
Your One Stop for Excel Tips & Solutions

a little involved


Posted by david Rainey on April 20, 2000 9:07 PM

i need to get the sum of the same 15 blocks
on about 15 different sheets on about ten
different spread sheets. Is there an easier way then to
just hit
sum(spreadsheet1(Sheet1!D1:D10)and
sum(spreadsheet1(sheet2!d1:d10)
sum(spreadsheet2(sheet1!d1:d10)
you get the picture


Posted by Nils on April 21, 2000 7:50 AM

Just name the 15 block range on sheet1. Whatever name you like I used "MyBlock" for this problem. Then in the cell on the other worksheets just type "=SUM(name)" or in my example case type =SUM(MyBlock), hit enter an the sum is there

Posted by david on April 21, 2000 10:01 PM


Problem is there are way too many of them though
lets see if i can format this ok
column1 column2 column3 column 4
3/28 56 56 120
4/02 16 5 120
4/15 15 8 190
4/16 10 0 612
4/21 11 15 12
now there are about ten sheets with this kind of info on it and
i need to add all of column 4 that is within two dates
such as i want all the dates in april
now there can be as many as 31 dates on one sheet
but there are 10 sheets on anywhere up to 21 workbooks
=SUM('c:\my documents\[worksheet1.xls]sheet1!$K$28:$K$43)
and i need to keep typing this out for sheets 2 through 10
then again for each of the other workbooks