Question about Microsoft Office Standard for PC

2 Answers

Formula for excel to add a number from one work sheet to another

Example: worksheet 1 ( P1 =2) need P1 in work sheet 2 to =3 & in worksheet 3 to + 4 etc etc etc

Posted by on

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 837 Answers

Are you saying you want to take info calculated CELL3 on worksheet1 and have that calculated and/or just copied to CELL3 (or whatever) an calculated and so on ...

Posted on Jan 12, 2009

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 160 Answers

Copy paste in the format u want on other excel document accordingly.

Posted on Jan 12, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hello, I have got a problem in excel and thought some expert here can solve it. I have a worksheet with thousands of rows, in following format 1:00:00 1:59:00 30/12/2009 3:00:00 3:59:00 30/12/2009...


There are two ways to solve it, with a macro and without.
In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.

With a formula, you can tell excel to put true if it is the case and correct it manually.

For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail lucho_lnc@yahoo.com

Mar 03, 2010 | Microsoft Excel for PC

2 Answers

Writing a formula for a sumif problem


Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

2 Answers

I Have list of numbers in coloumn in a sheet & i want its uniqe record in another sheet how it to do?


You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: http://www.cpearson.com/excel/Duplicates.aspx for any brainstorming :)

Mar 11, 2009 | Microsoft Business & Productivity Software

1 Answer

How do I add a number from one work sheet to another in excel ?


You can access numbers from another worksheet by using the formula (=SheetName!P1)
That would access cell P1 on the worksheet called "SheetName"

Jan 12, 2009 | Microsoft Office Standard for PC

1 Answer

Reference other worksheet in excel


eg if i want to add to numbers
in sheet 1 i have the value 20 in cell B3
in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

2 Answers

Unsure of correct formula


You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

Vloop


Are you referring to the VLOOKUP function in Microsoft Excel?

I love vlookup!

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title
123 Love Me Tender
234 Blue Suede Shoes
345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer
123 Elvis Presley
234 Carl Perkins
456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)
2. Haystack (Sheet2!A:B)
3. RELATIVE Col containing result (2)
4. Need DIRECT MATCH ONLY (0)

Hope this helps.

Jan 07, 2008 | Business & Productivity Software

1 Answer

Exel 2003


You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

1 Answer

Excel Coordinates don't show up in Formula Bar


Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Business & Productivity Software

3 Answers

About function


I love vlookup! Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B: Song# Title 123 Love Me Tender 234 Blue Suede Shoes 345 Dixie Another worksheet has song number and performer in Row 1, Cols A:B Song# Performer 123 Elvis Presley 234 Carl Perkins 456 Cher Notice there is NO performer for song number 345 in the 2nd worksheet. Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B) Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet. Help me out Mr. VLOOKUP. Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0) Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A. That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet. That is why I prefer VLOOKUP over LOOKUP. I have found this explaination of the VLOOKUP parameters helpful: 1. Needle (A2) 2. Haystack (Sheet2!A:B) 3. RELATIVE Col containing result (2) 4. Need DIRECT MATCH ONLY (0) Hope this helps. Let me know if you have any questions.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

18 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...