How do I create a formula using cells from two different sheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create formulas where the resulting data is on one sheet and
the parameters are on another sheet. I want to create something like this:
Sheet 1 cell A1*sheet 2 cell A1=Sheet 1 cell B1
 
Hi Elaine

in Sheet 1 cell B1 enter following formula:
=Sheet1!A1*Sheet2!A1

you can tell excel with a ! to which sheet the cell refers to.

hth

Carlo
 
=Sheet2!B1*Sheet2!B2
Put this in Sheet1, cell A1 (or anywhere else for that matter) and the
result will be Sheet2, cell B1 multiplied by Sheet2, cell B2.
You can type it manually or in the cell you want the result, enter an
'Equals' (=) sign, then select the cell in the other sheet, go back to the
original sheet and enter the multiplication sign (*) in the formula bar then
select the other cell in the other sheet and Excel will do it for you.
Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add hyperlink using sheet names and cells(i,j) 3
Vlookup and return sheet name also 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Referencing formula using Indirect 4
Worksheet linking 2
Excel IF Formulas 2
Cell entry 2
Assign Color to a Cell based on another Cell on a diff Sheet 1

Back
Top