I am trying to add 2 different wrk shts to a 3rd wrk sheet, one work sheet
(total 2005 has 2 lines for each company)
=('2005 Totals'!$B3+'Maintenance Dollars'!$B2)
=('2005 Totals'!$B5+'Maintenance Dollars'!$B3)
=('2005 Totals'!$B7+'Maintenance Dollars'!$B4)
as you can see the 2005 totals must skip a line, I've tried the offset in a
few ways (I start with B3 for the first formula because that is where the
value is), I just can't seem to get it to work so that I don't have to type
this formula in for every line, I just get error messages, anyone out there
who knows how to write the offset formula for me??? Thank you! Have a great
day!
Barb