# I have an assignment where 4 worksheets were provided. I did autosum for the total amounts on each sheet. I need to make a summary sheet now to add all of those totals What formula and steps do I take? I'm having some merge and center problems too.

Posted by on

• 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

I'd say you need to pay better attention to the Excel or other spreadsheet books and help you have handy, and categorize your problem according to the behavior you get inconsistent with the suggested solutions already available.

Posted on Nov 14, 2009

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How to calculate the percentage using the excel

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

Calculate the amount if you know the total and percentage For example, if you purchase a computer for \$800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

### 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

### Create link from system generated report to another sheet

the easiest way to do that is use hyperlink.
right click on the cell you want and select the hyperlink and link it to other worksheet or document you want.
one caution: if you are going to copy the worksheet to other than where it is now, you have to copy all of the attached worksheet and document. otherwise, you will get a error message.

Nov 05, 2008 | Microsoft Windows XP Home Edition

### Using Vlookup to copy data from another worksheet

=if(isblank(vlookup(Sheet1!A1,Sheet2!\$A\$1:\$B\$4,2,0)),"",vlookup(Sheet1!A1,Sheet2!\$A\$1:\$B\$4,2,0))

Sep 12, 2008 | Microsoft Excel for PC

### Attendance sheet in Excel

Hi KDina,

May 17, 2008 | Excel (SS8SATAS5128400R)

### 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

### 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

### Budgets in excel

I would recommend the use of the Table Function in Excel.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

Step 1:  Enter your data into the worksheet.

Step 2:  Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3:  Verify Table range is correct, Click OK

Step 4:  Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5:  To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6:  Enter new data in row

Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

### How do I work out the standard deviation, every time I try to work it out it keeps saying error 2.

The following table shows the total prize money recieved in 2007 to date for each of 31 seeded male players at this year's wimbledon. The amounts shown are to the nearest u\$100,000

27 33 7 16 9 8 7 3 4 6
4 6 7 7 4 5 3 4 4 2
7 3 6 5 2 3 4 3 3 2

Question?
Calculate the five figure summary of the total prize money recieved?

Sep 18, 2007 | Sharp EL-500LB Calculator

## Open Questions:

#### Related Topics:

46 people viewed this question

Level 3 Expert

Level 3 Expert