Question about Microsoft Excel 2010

One cell in the Worksheet works correctly - The result give me this result

Hi,

a 6ya expert can help you resolve that 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.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

SOURCE: import data from access into excel where one column go into one worksheet and other into next

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Posted on Jun 10, 2008

SOURCE: How to copy Excel worksheet in a word document?

go to Insert > File >select file and insert.

you have to select all documents when you when insert box opens.

Posted on Mar 16, 2009

SOURCE: FORMULA PROBLEM IN MS EXCEL

Are you trying to include the sum cell in your calculation - Check the formula bar.

Posted on May 10, 2009

SOURCE: Problem was found in Micorsoft

Once you have copy the cell from where the formula cam from, on the destination cell,

go to

1. Edit

2. Paste Special

3. Formula.

4. Press Enter

This should resolve your problem. Regards.

Posted on Aug 18, 2010

- Select a cell
- in the Fx section type =SUM(
- Click another cell
- The cell should highlight and the Fx should display (for instance =SUM(C3
- modify the Fx to read =SUM(C3-
- Click another cell
- Fx should read (for instance) =SUM(C3-D3
- Modify the Fx to read =SUM(C3-D3) by adding a closing bracket
- Put a number in C3
- Put a number in D3
- B3 will display the result of the subtraction

Mar 08, 2015 | Microsoft Excel 2010

Sounds like your issue can be solved readily with a pivot table.

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:

- See more at: http://www.exceldigest.com/myblog/2012/04/29/how-to-change-worksheet-direction-in-excel-2010-to-right-to-left/#sthash.lSG25YXq.dpuf

- In Excel Ribbon click on the Page Layout tab.
- In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.

- See more at: http://www.exceldigest.com/myblog/2012/04/29/how-to-change-worksheet-direction-in-excel-2010-to-right-to-left/#sthash.lSG25YXq.dpuf

May 27, 2014 | Microsoft Excel 2010

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.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- 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.

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.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- 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

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

Hi saleem_share,

I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:

Description

Amount

Formula

Sales Product A

1,000.00

Sales Product B

1,000.00

Total Sales

2,000.00

SUM(C1:C2)

Cost of Sales Product A

500.00

Cost of Sales Product B

200.00

Total Cost of Sales

700.00

SUM(C5:C6)

Gross Profit

1,300.00

SUM(C4-C7)

Auto

25.00

Utilities

50.00

Payroll

300.00

Office Supplies

20.00

Total Expenses

395.00

Net Profit

905.00

SUM(C8-C14)

I hope this helps

Mark

I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:

Description

Amount

Formula

Sales Product A

1,000.00

Sales Product B

1,000.00

Total Sales

2,000.00

SUM(C1:C2)

Cost of Sales Product A

500.00

Cost of Sales Product B

200.00

Total Cost of Sales

700.00

SUM(C5:C6)

Gross Profit

1,300.00

SUM(C4-C7)

Auto

25.00

Utilities

50.00

Payroll

300.00

Office Supplies

20.00

Total Expenses

395.00

Net Profit

905.00

SUM(C8-C14)

I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

Go to the cell you want this total in.

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table

table_to_check = the table you want to find the data from

column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.

range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here

B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)

G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)

etc

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table

table_to_check = the table you want to find the data from

column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.

range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here

B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)

G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)

etc

Jul 12, 2008 | Excel (SS8SATAS5128400R)

a b c d

1 item cost qty =c1*b1

2 item cost qty =c2*b2

total =sum(d1.d2)

all quantities should be blank except for the items you want to total.

1 item cost qty =c1*b1

2 item cost qty =c2*b2

total =sum(d1.d2)

all quantities should be blank except for the items you want to total.

Oct 25, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Dear Madiha35,

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

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

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

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

Aug 06, 2015 | Microsoft Excel 2010

May 09, 2017 | Microsoft Excel 2010

19 people viewed this question

Usually answered in minutes!

×