Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
metalurgia_lemos
 
Posts: n/a
Default How I can combine cells of different pages?

I mean how can I add, divide, mutliply, and so on figures of different cells
for example, add a figure of the cell f4 of the page 1 with the cell g5 of
the page 2.
  #2   Report Post  
Pat Flynn
 
Posts: n/a
Default

When you say page 1 & page 2 I assume you mean sheet 1 & sheet 2. You can
apply mathematic functions for a cell using different sheets but you have to
name the source i.e. =A1+Sheet2!A1. An easy way to do this is begin your
formula on sheet 1 = A1+ and then go to the cell in the sheet where it
resides, click on the cell and click on your active sheet. Excel will
automatically place the name reference of the cell and the sheet in using the
correct syntax.
Pat

"metalurgia_lemos" wrote:

I mean how can I add, divide, mutliply, and so on figures of different cells
for example, add a figure of the cell f4 of the page 1 with the cell g5 of
the page 2.

  #3   Report Post  
greg7468
 
Posts: n/a
Default


Hi,
highlight the cell where you want your answer to be

click on the = sign on the formula bar at the top of the sheet

click on the first cell (F4 on page 1)

type in "+"

click on the second sheet and cell G5,

you should now have in the formula bar

=F4+Sheet2!G5

press enter.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=378987

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill cells from non-adjacent cells Abes Excel Discussion (Misc queries) 2 March 25th 05 01:15 PM
REVISED ?? - populate limited cells w/ set value Jane Excel Worksheet Functions 1 March 19th 05 02:29 PM
Blank Cells in Pivot Tables Greg Excel Discussion (Misc queries) 1 March 16th 05 09:23 PM
combine the text or digit in different cells hande Excel Discussion (Misc queries) 1 January 6th 05 02:44 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"