Velocity Reviews > Basic spreadsheet questions

Samuel Sheet
Guest
Posts: n/a

 04-01-2005
As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2, \$4000
entered in Cell C1 of Sheet 3, what is the formula to add these amounts to
the sum of \$5000 which has been entered in Cell A1 of Sheet 1 so that A1 in
sheet 1 shows a total of the three cells of \$12,000? I guess there must be
complete interconnectivity between the sheets, but I couldn't work out the
correct formula to link them mathematically after studying the help pages.

Also, can you create more than 3 sheets which can connect to each other?

Sam

Gordon
Guest
Posts: n/a

 04-01-2005
On Fri, 01 Apr 2005 16:41:57 +1200, Samuel Sheet wrote:

> As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
> Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2, \$4000
> entered in Cell C1 of Sheet 3, what is the formula to add these amounts to
> the sum of \$5000 which has been entered in Cell A1 of Sheet 1 so that A1 in
> sheet 1 shows a total of the three cells of \$12,000? I guess there must be
> complete interconnectivity between the sheets, but I couldn't work out the
> correct formula to link them mathematically after studying the help pages.

Whew, my response is, *new* user, or someone who is trying to run before
they can walk?

BTW, I have seen this situation many times on USNET, and no doubt will
again shortly.

Also is Sheet your surname/family name? Sorry.

samual
Guest
Posts: n/a

 04-01-2005
"Samuel Sheet" <(E-Mail Removed)> wrote:

> As a new spreadsheet user, I see that Microsoft Excel opens with

why not ask at one of the many Excel groups ?

like microsoft.public.excel.newusers

Sheet 1, Sheet 2, and Sheet 3. If I have \$3000 entered in Cell
> B1 of Sheet 2, \$4000 entered in Cell C1 of Sheet 3, what is the
> formula to add these amounts to the sum of \$5000 which has been
> entered in Cell A1 of Sheet 1 so that A1 in sheet 1 shows a
> total of the three cells of \$12,000? I guess there must be
> complete interconnectivity between the sheets, but I couldn't
> work out the correct formula to link them mathematically after
> studying the help pages.
>
> Also, can you create more than 3 sheets which can connect to
> each other?
>
>
> Sam
>
>
>
>

Samuel Sheet
Guest
Posts: n/a

 04-01-2005

"Gordon" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> On Fri, 01 Apr 2005 16:41:57 +1200, Samuel Sheet wrote:
>
>> As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
>> Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2,
>> \$4000
>> entered in Cell C1 of Sheet 3, what is the formula to add these amounts
>> to
>> the sum of \$5000 which has been entered in Cell A1 of Sheet 1 so that A1
>> in
>> sheet 1 shows a total of the three cells of \$12,000? I guess there must
>> be
>> complete interconnectivity between the sheets, but I couldn't work out
>> the
>> correct formula to link them mathematically after studying the help
>> pages.

>
> Whew, my response is, *new* user, or someone who is trying to run before
> they can walk?
>
> BTW, I have seen this situation many times on USNET, and no doubt will
> again shortly.
>
> Also is Sheet your surname/family name? Sorry.

My friends call me "Bull", I'm not sure why. Anyway, I don't think you
answered the question, is there a simple answer to this? I used to work with
Lotus 123 many years ago, so I am not completely green as far as

Sam

cowboyz
Guest
Posts: n/a

 04-01-2005

Samuel Sheet wrote:
> As a new spreadsheet user, I see that Microsoft Excel opens with
> Sheet 1, Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of
> Sheet 2, \$4000 entered in Cell C1 of Sheet 3, what is the formula to
> add these amounts to the sum of \$5000 which has been entered in Cell
> A1 of Sheet 1 so that A1 in sheet 1 shows a total of the three cells
> of \$12,000? I guess there must be complete interconnectivity between
> the sheets, but I couldn't work out the correct formula to link them
> mathematically after studying the help pages.
> Also, can you create more than 3 sheets which can connect to each
> other?
>
> Sam

=Sheet1!A1+Sheet2!A1

basically "Sheet1!" denotes which sheet it gets the formula from. Right
click the tabs at the bottom and you can create however many sheets you
want.

Samuel Sheet
Guest
Posts: n/a

 04-01-2005
Thanks very much Jerry and cowboyz, I have now got this formula to work. Yes
Jerry, you are quite correct about the circular reference.

Sam

"Jerry" <(E-Mail Removed)> wrote in message
news:424cdda0\$(E-Mail Removed)...
> Samuel Sheet wrote:
>> As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
>> Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2,
>> \$4000 entered in Cell C1 of Sheet 3, what is the formula to add these
>> amounts to the sum of \$5000 which has been entered in Cell A1 of Sheet 1
>> so that A1 in sheet 1 shows a total of the three cells of \$12,000? I
>> guess there must be complete interconnectivity between the sheets, but I
>> couldn't work out the correct formula to link them mathematically after
>> studying the help pages.
>>
>> Also, can you create more than 3 sheets which can connect to each other?
>>
>>
>> Sam

>
> To create another sheet just click insert > worksheet. Your formula won't
> work, it creates a circular reference. The formula would be
> =SUM(A1,Sheet2!B1,Sheet3!C1) but you cannot put it in one of the cells
>
> Jerry

Jerry
Guest
Posts: n/a

 04-01-2005
Samuel Sheet wrote:
> As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
> Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2, \$4000
> entered in Cell C1 of Sheet 3, what is the formula to add these amounts to
> the sum of \$5000 which has been entered in Cell A1 of Sheet 1 so that A1 in
> sheet 1 shows a total of the three cells of \$12,000? I guess there must be
> complete interconnectivity between the sheets, but I couldn't work out the
> correct formula to link them mathematically after studying the help pages.
>
> Also, can you create more than 3 sheets which can connect to each other?
>
>
> Sam

To create another sheet just click insert > worksheet. Your formula
won't work, it creates a circular reference. The formula would be
=SUM(A1,Sheet2!B1,Sheet3!C1) but you cannot put it in one of the cells

Jerry

Peter
Guest
Posts: n/a

 04-01-2005
Jerry wrote:
> To create another sheet just click insert > worksheet. Your formula
> won't work, it creates a circular reference. The formula would be
> =SUM(A1,Sheet2!B1,Sheet3!C1) but you cannot put it in one of the cells

You might find it easier to use the mouse than it is to type in that long
cell address (and the mouse way is less error prone, too).

That is, in the cell where you want the result, type =
then click the sheet 2 tab, then cell B1
then press +
then click the sheet 3 tab, then cell C1
then press ENTER

HTH

Peter

Enkidu
Guest
Posts: n/a

 04-01-2005
Samuel Sheet wrote:
> As a new spreadsheet user, I see that Microsoft Excel opens with Sheet 1,
> Sheet 2, and Sheet 3. If I have \$3000 entered in Cell B1 of Sheet 2, \$4000
> entered in Cell C1 of Sheet 3, what is the formula to add these amounts to
> the sum of \$5000 which has been entered in Cell A1 of Sheet 1 so that A1 in
> sheet 1 shows a total of the three cells of \$12,000? I guess there must be
> complete interconnectivity between the sheets, but I couldn't work out the
> correct formula to link them mathematically after studying the help pages.
>
> Also, can you create more than 3 sheets which can connect to each other?
>

=C4+Sheet2!D10+Sheet3!B3

This adds C4 of Sheet 1 to D10 of Sheet2 to B3 of Sheet 3.

You can have as many sheets as you like.

Cheers,

Cliff

--

Barzoomian the Martian - http://barzoomian.blogspot.com

Jerry
Guest
Posts: n/a

 04-01-2005
Samuel Sheet wrote:
> Thanks very much Jerry and cowboyz, I have now got this formula to work. Yes
> Jerry, you are quite correct about the circular reference.
>

Jerry