Velocity Reviews > Basic spreadsheet questions

# 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?

Thanks for your help.

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?
>
> Thanks for your help.
>
> 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
spreadsheets go!

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?
> Thanks for your help.
>
> 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?
>>
>> Thanks for your help.
>>
>> 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
> that you are adding.
>
> 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?
>
> Thanks for your help.
>
> 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
that you are adding.

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
> that you are adding.

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.
>

Glad to help

Jerry

 Thread Tools

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post The Natural Philosopher Javascript 2 07-04-2007 05:49 PM Jimmy Dean Computer Support 3 07-25-2005 07:05 AM Samuel Sheet Computer Support 20 04-27-2005 02:06 AM Patrick Michael A+ Certification 0 06-16-2004 04:53 PM Jaime MCSD 2 09-20-2003 05:16 AM

Advertisments