is_utf8:0,
 
Search : in
By :

Excel formula for one sheet to another

Last answer on Oct 29, 2009 12:54:15 pm GMT danny, on Oct 29, 2009 7:50:14 am GMT 
 Report this message to moderators

Hello,
in excell 2007 Sheet 1 maintaing invoice and sheet 2 invoice summary .
i need formula to get the summary total amount in sheet 1 inoice bill.

please help

Configuration: Windows XP Internet Explorer 7.0

Best answers for « excel formula for one sheet to another » in :
Excel formula to get the cell with the text Show
Comparing two excel sheets Show
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Download Unit Converter for Excel ShowIt is not always necessary to use an expensive or sophisticated program or to convert measurement units. It is sometimes enough to use Excel worksheet by only adding a plug-in. Unit Converter for Excel is one of Microsoft Excel plug-in which can...
UNIX system - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence its name "shell". The shell therefore acts as an intermediary between the operating system and the user using command lines...
Ask your question Reply

1

 Trowa, on Oct 29, 2009 12:54:15 pm GMT
  • +1

To call a cell on a different sheet use the sheets name followed by an exclamation mark in front of the cell, like this:
=Sheet1!A1

   
Reply to Trowa
Ask your question Reply
They need your help