C
charlie
we are trying to set up a spread sheet that contains two columns. One would
have current expenditures and the the second would be YTD. We want to have
the YTD update when we change the current to add the current amount to the
previous YTD. We only want one line for each expense
1 A B C D
2 Expense Current YTD
3 office supplies $10000 $ 10000
4
5 Printing $ 2000 $ 2000
____________________________________________________________________
next posting to current posting
A B C D
1 Expense Current YTD
2 office supplies $5000 $ 15000
3
4 Printing $ 800 $2800
is there a way to say- =sum(B2+ D2) so that it will add the new current
number to the YTD previous YTD. Does this make any sense?
have current expenditures and the the second would be YTD. We want to have
the YTD update when we change the current to add the current amount to the
previous YTD. We only want one line for each expense
1 A B C D
2 Expense Current YTD
3 office supplies $10000 $ 10000
4
5 Printing $ 2000 $ 2000
____________________________________________________________________
next posting to current posting
A B C D
1 Expense Current YTD
2 office supplies $5000 $ 15000
3
4 Printing $ 800 $2800
is there a way to say- =sum(B2+ D2) so that it will add the new current
number to the YTD previous YTD. Does this make any sense?