use result from 1 formula in another in another sheet

G

g29115

Hello all,

I am having trouble with something that normally seems like no issue. I
have a formula in a cell in one sheet. On sheet 2 I want to add the
result from the first formula into another formula to get a new result.
For instance:

[SHEET 1, cell a1]

=POWER(c3,0.222)

Now in [SHEET 2, cell a1] I have the formula:

=SUM(b5* ?)

where the "?" needs to be the result from the formula in SHEET 1, a1.
I want that first formula result to be automatically taken and placed
in the second formula and then have the 2nd formula calculate
correctly.

So far I have not found the correct way to do it. Mind you, the result
in the second formula is formated for time mm:ss.0 For what that is
worth.

Any help appreciated!! G.
 
B

Bob Phillips

=SUM(B5*Sheet1!A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

g29115

-> Bob Phillips =SUM(B5*Sheet1!A1)

Thanks Bob! I just figured it out and got it right just before I
checked back. Now the next question I have is thus:

if I want to use that same formula in a column of data but DO NOT want
the A1 part to advance, how can I get it to stay the same for all the
cells? I.E.:

=SUM(B5*Sheet1!A1)

next cell

=SUM(B6*Sheet1!A1)

then

=SUM(B7*Sheet1!A1)

ETC

If I try to copy the first formula then highlight the cells in the rest
of the column and then paste it advances the A1 to A2 to A3 etc. I need
the A1 to stay constant. Is there anyway to do this?

Thanks, G.
 
B

Bob Phillips

GO,

Absolute reference, that is

=SUM(B5*Sheet1!$A$1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

Is there a real reason you want to wrap your formula with =sum()?

=b5*sheet1!$a$1

would work ok.
Hello all,

I am having trouble with something that normally seems like no issue. I
have a formula in a cell in one sheet. On sheet 2 I want to add the
result from the first formula into another formula to get a new result.
For instance:

[SHEET 1, cell a1]

=POWER(c3,0.222)

Now in [SHEET 2, cell a1] I have the formula:

=SUM(b5* ?)

where the "?" needs to be the result from the formula in SHEET 1, a1.
I want that first formula result to be automatically taken and placed
in the second formula and then have the 2nd formula calculate
correctly.

So far I have not found the correct way to do it. Mind you, the result
in the second formula is formated for time mm:ss.0 For what that is
worth.

Any help appreciated!! G.
Click to expand...
 
K

Ken Wright

You don't need the SUM bit either :)

=B5*Sheet1!$A$1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :)
----------------------------------------------------------------------------



Bob Phillips said:
GO,

Absolute reference, that is

=SUM(B5*Sheet1!$A$1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
K

Ken Wright

LOL - Dohhhhhhh!!!! Working my way through the threads, posted the same damn
comment and then next clicked onto yours :-(

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :)
----------------------------------------------------------------------------



Dave Peterson said:
Is there a real reason you want to wrap your formula with =sum()?

=b5*sheet1!$a$1

would work ok.
Hello all,

I am having trouble with something that normally seems like no issue. I
have a formula in a cell in one sheet. On sheet 2 I want to add the
result from the first formula into another formula to get a new result.
For instance:

[SHEET 1, cell a1]

=POWER(c3,0.222)

Now in [SHEET 2, cell a1] I have the formula:

=SUM(b5* ?)

where the "?" needs to be the result from the formula in SHEET 1, a1.
I want that first formula result to be automatically taken and placed
in the second formula and then have the 2nd formula calculate
correctly.

So far I have not found the correct way to do it. Mind you, the result
in the second formula is formated for time mm:ss.0 For what that is
worth.

Any help appreciated!! G.
Click to expand...
Click to expand...
 
B

Bob Phillips

No I know, but it was the referencing that was important for the OP.

Bob

Ken Wright said:
You don't need the SUM bit either :)

=B5*Sheet1!$A$1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
Seasons Greetings and Very Best wishes to all :)
-------------------------------------------------------------------------- --
Click to expand...
 
K

Ken Wright

LOL - Sorry Bob - I had assumed that anyway, and the comment was meant for the
OP not you :)
 
B

Bob Phillips

Ken,

Sorry, didn't mean to come across as I did. Sometimes I just respond
directly to the question, sometimes I try and be a bit 'more helpful', and
invariably one can do better in many cases. There is no set answer because
it is difficult to know what the OP wants and understands.

Getting late and tired I guess.

Regards

Bob
 
Top