F
Forgone
I've really got myself confused on how to figure this out and need
some assistance.
I'm working on a financial worksheet and have been getting away with
YTD budget formulas using a total figure and dividing it by the number
of months I'm reporting on. Except now they want to enter the month
they want to report on and it will sum up a number of columns.
In the budget.month worksheet there is a series of fields:
CCA, CCB, CCC, CCD, CCE, CCF, Period 1, Period 2, Period 3, Period 4,
Period 5, Period 6, Period 7, Period 8, Period 9, Period 10, Period 11
and Period 12.
The formula I'm using in the Report worksheet is currently.......
{=(SUM((O9B.CCB=VALUE(C7))*(O9B.CCD=VALUE(rep.fund))*
(O9B.cat="Expense")*(O9B.Amounts)))/4}
O9B stands for 08/09 Budget
the rest is self explanatory.
The Value in C7 is the costcentre aka CCB
Thus what I want to do is extend on this ( {=(SUM((O9B.CCB=VALUE(C7))*
(O9B.CCD=VALUE(rep.fund))*(O9B.cat="Expense")* ) with something along
these lines.....
The reporting.month cell is where the user will enter which period:
EG: 6 for July to December. The formula will then sum the values in
the columns Period 1, 2, 3, 4, 5, 6
I'm not sure which way to do it without creating some mega formula
that goes along the lines of (IF(reporting.month=1,(Period 1),If
(reporting.month=2,(Period 1)*(Period 2),if(reporting.month=3,(Period
1)*(Period 2)*(Period 3)......... any ideas on how to tackle this
one..... I am stuck.
some assistance.
I'm working on a financial worksheet and have been getting away with
YTD budget formulas using a total figure and dividing it by the number
of months I'm reporting on. Except now they want to enter the month
they want to report on and it will sum up a number of columns.
In the budget.month worksheet there is a series of fields:
CCA, CCB, CCC, CCD, CCE, CCF, Period 1, Period 2, Period 3, Period 4,
Period 5, Period 6, Period 7, Period 8, Period 9, Period 10, Period 11
and Period 12.
The formula I'm using in the Report worksheet is currently.......
{=(SUM((O9B.CCB=VALUE(C7))*(O9B.CCD=VALUE(rep.fund))*
(O9B.cat="Expense")*(O9B.Amounts)))/4}
O9B stands for 08/09 Budget
the rest is self explanatory.
The Value in C7 is the costcentre aka CCB
Thus what I want to do is extend on this ( {=(SUM((O9B.CCB=VALUE(C7))*
(O9B.CCD=VALUE(rep.fund))*(O9B.cat="Expense")* ) with something along
these lines.....
The reporting.month cell is where the user will enter which period:
EG: 6 for July to December. The formula will then sum the values in
the columns Period 1, 2, 3, 4, 5, 6
I'm not sure which way to do it without creating some mega formula
that goes along the lines of (IF(reporting.month=1,(Period 1),If
(reporting.month=2,(Period 1)*(Period 2),if(reporting.month=3,(Period
1)*(Period 2)*(Period 3)......... any ideas on how to tackle this
one..... I am stuck.