Please Help All You Microsoft Excel Wizards!?
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.
send it to me in an e-mail (as an attatchment) and I'll fix it for you. marykay.lady@yahoo.com
send it to me in an e-mail (as an attatchment) and I'll fix it for you. marykay.lady@yahoo.com
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)
=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)
all you have to do is highlight one collumn at a time and click autosum
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.
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).