use result from 1 formula in another in another sheet

  • Thread starter Thread starter g29115
  • Start date Start date
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.
 
=SUM(B5*Sheet1!A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
-> 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.
 
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)
 
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...
 
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...
 
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...
 
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...
 
LOL - Sorry Bob - I had assumed that anyway, and the comment was meant for the
OP not you :-)
 
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
 
Back
Top