B
Bart
Hopefully I can explain this better. I have two worksheets
which I've tried to explain the formulas I need :
sheet a (Total Charges)
salaries 0 cumulative total
travel 100 cumulative total
sheet b (Monthly Charges)
I have 13 columns Jan - Dec which must equal a total
budgeted column.
salaries
Jan =if(date is jan., total charges, total charges at end
of jan.)
Feb =if(date is feb., total charges MINUS Jan.,(total
budgeted - jan)/months left in yr)
March =if(date is march, total charges MINUS Jan. + Feb.,
(total budgeted - (jan+feb)/months left in yr)
My problem is I end up getting a circular reference among
other problems.
My goal is to have sheet b manually update by the date
therefore never having to do any input on that sheet.
Any help is appreciated.
which I've tried to explain the formulas I need :
sheet a (Total Charges)
salaries 0 cumulative total
travel 100 cumulative total
sheet b (Monthly Charges)
I have 13 columns Jan - Dec which must equal a total
budgeted column.
salaries
Jan =if(date is jan., total charges, total charges at end
of jan.)
Feb =if(date is feb., total charges MINUS Jan.,(total
budgeted - jan)/months left in yr)
March =if(date is march, total charges MINUS Jan. + Feb.,
(total budgeted - (jan+feb)/months left in yr)
My problem is I end up getting a circular reference among
other problems.
My goal is to have sheet b manually update by the date
therefore never having to do any input on that sheet.
Any help is appreciated.