I am having problems adding values from previous worksheets in a
workbook.

I realize that I must reference the sheet in my formulas, but I am
doing this for many multiple columns and rows. Below is the formula
that I am using in one column:

=SUM(Sheet1!$F$17,Sheet1!$H$17,Sheet1!$J$17,Sheet1 !$L$17,Sheet1!$N$17,Sheet1!$P$17,Sheet1!$R$17)

I am having to change all the sheet #’s in my formulas for every time I
create a copy of the previous worksheet, and I am creating one worksheet
for every week of the year. Way too much typing since this formula is
being used in so many cells.

I got searching around and I found a function that I think would work.
It is located he

http://tinyurl.com/8pdas

But since I am so new to Excel, I am having difficulty understanding
how to use it. Am I close in any of my assumptions or am I way off
base?

If I do need to use part of the function in the above address, can
someone show me how to use it and maybe give me a simple example so I
can type it into Excel and see it work. Then I could probably
understand how to apply it to my application.

Thanks…
New To Excel


--
firecord
------------------------------------------------------------------------
firecord's Profile: http://www.excelforum.com/member.php...o&userid=24490
View this thread: http://www.excelforum.com/showthread...hreadid=382358