N
noy
Hi - hopefully there is someone who can assist. I have a question about data.
I have a tracking spreadsheet with 5 sheets, the back for are for different
subjects but each shows the actions due each month and each month the actions
completed are entered.
This pulls together into a front sheet which all works fine, but I can not
find a way to total up the total actions complete on a month by month basis.
For example
Jan Feb Mar
Sheet 1 Actions due 2 1 3 (cell
A1,A2,A3)
Sheet 1 Actions complete 1 1 2 (cell
B1,B2,B3)
Sheet 2 Actions due 4 7 2 (cell
A1,A2,A3)
Sheet 3 Actions complete 4 0 6 (cell
B1,B2,B3)
I've put a drop down list in one cell on the front summary sheet, how do I
then use this is the next cells to show how on track things are?
So in Jan there should have been 6 actions complete and 5 are. In Feb there
should have been 14 actions done (Jan and Feb figs combined) but only 6 have
been. Obviously this will continue to years end.
Any tips at all??? Thanks in advance.. Noy
I have a tracking spreadsheet with 5 sheets, the back for are for different
subjects but each shows the actions due each month and each month the actions
completed are entered.
This pulls together into a front sheet which all works fine, but I can not
find a way to total up the total actions complete on a month by month basis.
For example
Jan Feb Mar
Sheet 1 Actions due 2 1 3 (cell
A1,A2,A3)
Sheet 1 Actions complete 1 1 2 (cell
B1,B2,B3)
Sheet 2 Actions due 4 7 2 (cell
A1,A2,A3)
Sheet 3 Actions complete 4 0 6 (cell
B1,B2,B3)
I've put a drop down list in one cell on the front summary sheet, how do I
then use this is the next cells to show how on track things are?
So in Jan there should have been 6 actions complete and 5 are. In Feb there
should have been 14 actions done (Jan and Feb figs combined) but only 6 have
been. Obviously this will continue to years end.
Any tips at all??? Thanks in advance.. Noy