Dan_K_2014
Member
Hello,
Would you please help me to write formulas in columns E,F, H, I, rows 4:15.
ROWS C & D are empty.
In E and F numbers will be coming from the Actual table results by months From January to December; and in H, I- from targets.
Numbers should be changing in E,F,H, I after selection of the month in cell E3 and type of product in H1.
The tables of the actual and targets data have the same format as this summary table from A to E. After E (January) from F to P (February and December).
Thank you.
I wanted to upload a file, but it does not have an option for Excel...
Overall Types
Type 1
B
C
D
Actual
Target
Variance
Actual
Target
Variance
Jan-15
Jan-15
Jan-15
Jan-15
Jan-15
Jan-15
P1 - New Patients
P2 - 2nd Month Patients
P3 - 3rd Month Patients
P4 - Patients > 3 Months
P1 - New Patients' Billings
P1 - Billings per Patient
P2 - 2nd Month Patients' Billings
P2 - Billings per Patient
P3 - 3rd Month Patients' Billings
P3 - Billings per Patient
P4 - Patients > 3 Months Billings
P4 - Billings per Patient
Would you please help me to write formulas in columns E,F, H, I, rows 4:15.
ROWS C & D are empty.
In E and F numbers will be coming from the Actual table results by months From January to December; and in H, I- from targets.
Numbers should be changing in E,F,H, I after selection of the month in cell E3 and type of product in H1.
The tables of the actual and targets data have the same format as this summary table from A to E. After E (January) from F to P (February and December).
Thank you.
I wanted to upload a file, but it does not have an option for Excel...
Overall Types
Type 1
B
C
D
Actual
Target
Variance
Actual
Target
Variance
Jan-15
Jan-15
Jan-15
Jan-15
Jan-15
Jan-15
P1 - New Patients
P2 - 2nd Month Patients
P3 - 3rd Month Patients
P4 - Patients > 3 Months
P1 - New Patients' Billings
P1 - Billings per Patient
P2 - 2nd Month Patients' Billings
P2 - Billings per Patient
P3 - 3rd Month Patients' Billings
P3 - Billings per Patient
P4 - Patients > 3 Months Billings
P4 - Billings per Patient
Last edited by a moderator: