I have a budget worksheet that keep track of my expense each month.
Jan Feb Mar Apr May ….
Food 1 125 96 0 0
Rent 5 5 5 0 0
… … .. ..
Sum 1230 15 1696
etc
Last month expense is :($1696)
In my Last month expense is (), how do I refer to the last month’s sum? This example is point to March’s total, but next time will be April.
Next question:
If I have tab, called JAN, FEB, MAR, APR etc..
and I have a big summry sheet, summarizing all months’ info..
Without manual go thru all cells pointing to each worksheet, how can I refer to “first worksheet of the workbook”, “second worksheet of the workbook” etc etc?
1 Answer
? Favorite Answer
1 – I would suggest an IF formula working from Right to Left as follows (assuming Jan is in Column B and Dec in column M and your Sum total is on Row 10):
=if(M10>0,M10,if(L10>0,L10,if(K10>0,K10,if………. and so on.
For your summary sheet, this will only work if the structure of each sheet you’re adding is identical, i.e. Jan is in B2, December Sum is in M13, etc.
Type in =Sum(
Click on the first sheet you want to add. Click on the cell which will be added on each worksheet.
Hold down Shift on your keyboard
Click on the last sheet you want to add
Release Shift and press enter.
This selects all sheets inbetween the first and last and adds the cell (e.g. E5) on every sheet.