Hello, I asked this question a few days ago and someone answered me and it
worked but by looking at what I needed it seems to be more extensive than
antisapated so I need assistance. Ok, I have a workbook with several
worksheets in it, each worksheet is set up the same. I want to have a main
worksheet that will draw totals from all my other worksheets. My worksheets
are named by date and the first being (Week Ending 2-26-6) and the last as of
now is (Week Ending 9-24-2006) someone gave me this for my function
(=sum(firstsheet:lastsheet!a1). It works if my sheets are named sheet1 and so
on but like stated above thay are not. I tried using =Sum(Week Ending
2-26-6:Week Ending 9-24-2006!L10,R10,Z10,AF10,AL10,AR10) but it just gives me
an error! I just want a total rome these cells from my starting worksheet to
my ending worksheet. Please help....

Thanks!
Chad

A) This sums the A30 cells in all sheets: =SUM('sheet a:sheet d'!A30)
B) This sums A30+B30: =SUM('sheet a:sheet d'!A30) + SUM('sheet a:sheet
d'!B30)
C) This sums a range: =SUM('sheet a:sheet d'!A30:A50)

Could you sum L10, R10, Z10, AF10, AL10, AR10 into one cell on each sheet
and use form (A) above to consolidate?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"oxicottin" <(E-Mail Removed)> wrote in message
news:ADB52911-96C0-49A6-82FE-(E-Mail Removed)...
> Hello, I asked this question a few days ago and someone answered me and it
> worked but by looking at what I needed it seems to be more extensive than
> antisapated so I need assistance. Ok, I have a workbook with several
> worksheets in it, each worksheet is set up the same. I want to have a main
> worksheet that will draw totals from all my other worksheets. My
> worksheets
> are named by date and the first being (Week Ending 2-26-6) and the last as
> of
> now is (Week Ending 9-24-2006) someone gave me this for my function
> (=sum(firstsheet:lastsheet!a1). It works if my sheets are named sheet1 and
> so
> on but like stated above thay are not. I tried using =Sum(Week Ending
> 2-26-6:Week Ending 9-24-2006!L10,R10,Z10,AF10,AL10,AR10) but it just gives
> me
> an error! I just want a total rome these cells from my starting worksheet
> to
> my ending worksheet. Please help....
>
> Thanks!
> Chad
>
>

Thanks for the info it is really helpfull but, I do need to sum it all onto
one worksheet. What name do I use in the formula? sheet a ect or what I named
the sheet like Week Ending ect.? When I get that total onto my main worksheet
I have to do other functions besides that to get the numbers Im looking for.

"Bernard Liengme" wrote:

> A) This sums the A30 cells in all sheets: =SUM('sheet a:sheet d'!A30)
> B) This sums A30+B30: =SUM('sheet a:sheet d'!A30) + SUM('sheet a:sheet
> d'!B30)
> C) This sums a range: =SUM('sheet a:sheet d'!A30:A50)
>
> Could you sum L10, R10, Z10, AF10, AL10, AR10 into one cell on each sheet
> and use form (A) above to consolidate?
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "oxicottin" <(E-Mail Removed)> wrote in message
> news:ADB52911-96C0-49A6-82FE-(E-Mail Removed)...
> > Hello, I asked this question a few days ago and someone answered me and it
> > worked but by looking at what I needed it seems to be more extensive than
> > antisapated so I need assistance. Ok, I have a workbook with several
> > worksheets in it, each worksheet is set up the same. I want to have a main
> > worksheet that will draw totals from all my other worksheets. My
> > worksheets
> > are named by date and the first being (Week Ending 2-26-6) and the last as
> > of
> > now is (Week Ending 9-24-2006) someone gave me this for my function
> > (=sum(firstsheet:lastsheet!a1). It works if my sheets are named sheet1 and
> > so
> > on but like stated above thay are not. I tried using =Sum(Week Ending
> > 2-26-6:Week Ending 9-24-2006!L10,R10,Z10,AF10,AL10,AR10) but it just gives
> > me
> > an error! I just want a total rome these cells from my starting worksheet
> > to
> > my ending worksheet. Please help....
> >
> > Thanks!
> > Chad
> >
> >
>
>
>