Greetings,
still having trouble with cumulative totals despite all the great advice i have received on this board.
I have a formula sum(a1, e1, I1.......bb1) which adds up to a cumulative total for the year. However whilst I dont mind ppl entering figures for I1 (which represents march) i dont actually want it to add into the formula automatically.
I know i may be asking the impossible.......
Is there any way by using SumProduct, or conditional formatting or hiding the relevant cells that i can acheive
I cant really afford to go back and change all the formulas too much as, presently i have over 6000 which are affected by this.
once again thanks for all your advice, this is an excellent message board
scouse
still having trouble with cumulative totals despite all the great advice i have received on this board.
I have a formula sum(a1, e1, I1.......bb1) which adds up to a cumulative total for the year. However whilst I dont mind ppl entering figures for I1 (which represents march) i dont actually want it to add into the formula automatically.
I know i may be asking the impossible.......
Is there any way by using SumProduct, or conditional formatting or hiding the relevant cells that i can acheive
I cant really afford to go back and change all the formulas too much as, presently i have over 6000 which are affected by this.
once again thanks for all your advice, this is an excellent message board
scouse