Is there anyway to add totals of a particular row in a worksheet that can
change position in another worksheet and add the totals in a master sheet.
(I am making a roster and adding peoples shifts however sometimes I need to
add people to the list in various positions replacing others)
I know to use the offset or sumproduct formulas in each individual sheet but
don't know how to add all the sheets into a master.

Thanks
Graeme

I'd don't know if this works for you, but you may want to look at
Data|Pivottables. You can do nice summaries of table like data pretty
easily--once you get the hang of pivottables.

If you want to read more about the pivottable stuff, you may want to look at
some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

Graeme Moloney wrote:

Is there anyway to add totals of a particular row in a worksheet that can
change position in another worksheet and add the totals in a master sheet.
(I am making a roster and adding peoples shifts however sometimes I need to
add people to the list in various positions replacing others)
I know to use the offset or sumproduct formulas in each individual sheet but
don't know how to add all the sheets into a master.

Thanks
Graeme

--

Dave Peterson