Formulas

How would I set up a formula that consists of a sum on page 1 + a sum on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?

if all in the same cell
=sum(page1:pag5!a1)

--
Don Guillett
SalesAid Software
[email protected]
"amartin-kelly" <[email protected]> wrote in message
news:[email protected]...
> How would I set up a formula that consists of a sum on page 1 + a sum on
> page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?

Hi

Do you mean =SUM(Sheet1:Sheet5!A1:A20)

Regards

Roger Govier


amartin-kelly wrote:
> How would I set up a formula that consists of a sum on page 1 + a sum on
> page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?

hi
thank you for your information but when i do that (which is makes total
sense now that i think about it) ..i write the formula as
=sum(week1:week5!a8)
because we named the pages "week"
after i finish the formula it says something like #NAME!*? and tells me that
the name for "week1" is unrecongnizable.
any thoughts
thanks

"Don Guillett" wrote:

> if all in the same cell
> =sum(page1:pag5!a1)
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "amartin-kelly" <[email protected]> wrote in message
> news:[email protected]...
> > How would I set up a formula that consists of a sum on page 1 + a sum on
> > page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?
>
>
>

Funny, I just tested with a sheet named week1 and a sheet named week5.
Perhaps you have spaces or a leading or trailing space?

--
Don Guillett
SalesAid Software
[email protected]
"amartin-kelly" <[email protected]> wrote in message
news:[email protected]...
> hi
> thank you for your information but when i do that (which is makes total
> sense now that i think about it) ..i write the formula as
> =sum(week1:week5!a8)
> because we named the pages "week"
> after i finish the formula it says something like #NAME!*? and tells me
that
> the name for "week1" is unrecongnizable.
> any thoughts
> thanks
>
> "Don Guillett" wrote:
>
> > if all in the same cell
> > =sum(page1:pag5!a1)
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "amartin-kelly" <[email protected]> wrote in
message
> > news:[email protected]...
> > > How would I set up a formula that consists of a sum on page 1 + a sum
on
> > > page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?
> >
> >
> >

Thank You I figured it out and changed the names to the sheets with no spaces!
Thank you so much!! This post board has helped me out so much!

"Don Guillett" wrote:

> Funny, I just tested with a sheet named week1 and a sheet named week5.
> Perhaps you have spaces or a leading or trailing space?
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "amartin-kelly" <[email protected]> wrote in message
> news:[email protected]...
> > hi
> > thank you for your information but when i do that (which is makes total
> > sense now that i think about it) ..i write the formula as
> > =sum(week1:week5!a8)
> > because we named the pages "week"
> > after i finish the formula it says something like #NAME!*? and tells me
> that
> > the name for "week1" is unrecongnizable.
> > any thoughts
> > thanks
> >
> > "Don Guillett" wrote:
> >
> > > if all in the same cell
> > > =sum(page1:pag5!a1)
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > [email protected]
> > > "amartin-kelly" <[email protected]> wrote in
> message
> > > news:[email protected]...
> > > > How would I set up a formula that consists of a sum on page 1 + a sum
> on
> > > > page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?
> > >
> > >
> > >
>
>
>

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"amartin-kelly" <[email protected]> wrote in message
news:[email protected]...
> Thank You I figured it out and changed the names to the sheets with no
spaces!
> Thank you so much!! This post board has helped me out so much!
>
> "Don Guillett" wrote:
>
> > Funny, I just tested with a sheet named week1 and a sheet named week5.
> > Perhaps you have spaces or a leading or trailing space?
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "amartin-kelly" <[email protected]> wrote in
message
> > news:[email protected]...
> > > hi
> > > thank you for your information but when i do that (which is makes
total
> > > sense now that i think about it) ..i write the formula as
> > > =sum(week1:week5!a8)
> > > because we named the pages "week"
> > > after i finish the formula it says something like #NAME!*? and tells
me
> > that
> > > the name for "week1" is unrecongnizable.
> > > any thoughts
> > > thanks
> > >
> > > "Don Guillett" wrote:
> > >
> > > > if all in the same cell
> > > > =sum(page1:pag5!a1)
> > > >
> > > > --
> > > > Don Guillett
> > > > SalesAid Software
> > > > [email protected]
> > > > "amartin-kelly" <[email protected]> wrote in
> > message
> > > > news:[email protected]...
> > > > > How would I set up a formula that consists of a sum on page 1 + a
sum
> > on
> > > > > page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?
> > > >
> > > >
> > > >
> >
> >
> >