Facing the Excel sum problem

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by CapeSteve
Best Answer
Best Answer
Answered By 0 points N/A #101879

Facing the Excel sum problem

qa-featured

 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.

     

Answered By 10 points N/A #101880

Facing the Excel sum problem

qa-featured

It made my work easier and faster.

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

Login/Register to Answer

Related Questions