Facing the Excel sum problem

Asked By Daniel Hernandez 10 points N/A Posted on - 01/26/2012

I happen to be not a great excel professional due to any kind of extend so I am unsure whether or not this can be really possible. I do have a sheet that has a price list displaying reference number, outline, expense tax, cost income tax, margin, and profit along with market value.

It is around 650 rows long. I prefer to come up with an invoice in a new sheet and enter the reference number within a cell and then have this transfer in which the item files (description, margin and sell value) this is not likely to be the invoice I deal out to customers however, instead one who enables myself to determine work profit since it moves. I suppose I would most likely have to enter a sum for any item manually as well.

Can this appear feasible?

• Status: Open
• Question Views: 1228
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by CapeSteve

Go To Solution

Best Answer

Best Answer

Answered By CapeSteve 15 points N/A #101879

Facing the Excel sum problem

 Ok you have a sheet which is quite complete with data entry. Now you want to do sum operation among two or more columns.

• Click on the empty cell where you want to show sum result. Keep on mind the empty cell is in the same row where the two numbers (which are going to sum) are.
•  Then write formula. In Excel you need to start each and every formula by ‘=’ so write =sum(b2,c2) press enter. Here b2 (column b and row 2) and c2( column c and row 2). At these positions two numbers are placed.

• As you press enter sum results will be displayed.

• Now if you want to do that for each row. You don’t need to write formula for every row. You just need to drag the cell of first sum result downward to the 650 rows and drop it. sum results of their relative numbers on each row will be displayed.

   

About CapeSteve

Questions
1

Answers
59

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 01/27/2012
• Question Category: MS Excel

Answered By Daniel Hernandez 10 points N/A #101880

Facing the Excel sum problem

It made my work easier and faster.

Thank you for the suggestion and tips about how I'm going to work on excel.

About Daniel Hernandez

Questions
5

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/07/2012
• Question Category: MS Excel