Please help all you Microsoft Excel wizards!?

Question

I have created a list of 5 different expenses. I have then copied my Bank Statement onto Excel allocating each of my debits against one of the 5 expenses. Now I am wanting Excel to tally up all the figures so that at the end, I have the list of the 5 different expenses and how much money is assigned to each one.

Answer 1

send it to me in an e-mail (as an attatchment) and I'll fix it for you. [e-mail]

Answer 2

The specifics of how to do this vary based on how you have the data arranged. Assuming you have each Expense occupying a single row, and your debits in separate columns in that row, you could enter a formula to SUM($??:$??), where ?? = The starting cell for debits for this expense (IE. B2) and the second ?? = the ending cell (IE. H2).

Answer 3

there is not any version of Excel referred to as Vista Excel - so i'm uncertain which version you have. attempt the "Insert" menu. If not, in simple terms faucet the F1 key to open Excel help and then form Chart Wizard. this permit you comprehend all approximately it.

Answer 4

You can add cells that are not in one line by using the formula SUM and the holding ctrl and clicking on the cells you wish to add.

Answer 5

in the ending box, type things like:

=sum(A1:A5)
(this totals up contents in cell A1, A2, A3, A4, A5)

or

=A1+A2+A3-A4
(this adds A1 to A3 and deducts A4)

Answer 6

all you have to do is highlight one collumn at a time and click autosum