Hello! I am creating a monthly budget in excel. I have each month in a seperate worksheet. I would like to add up the left over (or negative) for each month in another worksheet. How can I do that without adding it myself. Or must I add it myself?
2006-10-01 01:55:52 · 3 answers · asked by shellyeliz 2 in Computers & Internet ➔ Software
From the cell where you want the total, type"=" then select the january worksheet tab and then the cell which has total left over, type "+" and then continue doing this for all months worksheet..and finally press enter
you can also write a macro but i guess its too complicated for doing a simple task...
2006-10-01 02:50:46 · answer #1 · answered by Siva 2 · 2⤊ 0⤋
i guess you have to do it pretty manually. but do make full use of linking n dragging down the formulas & using the ctrl H function....
2006-10-01 09:08:49 · answer #2 · answered by ant 1 · 0⤊ 0⤋
go to the library and get a book on excel it will teach you alot and good luck.
2006-10-01 08:58:51 · answer #3 · answered by Kate T. 7 · 0⤊ 1⤋