E
Eva
Hi
I have the following data
customer month actual costs monthly plan ytd plan
A 1 1 2 2
2 3 2 2
3 2
4 2
A Total sum of all above
The formula for YTD Plan is = if actual costs(C2) is not blank then monthly
plan (D2) =if C2<>"",d2,0
I woud like to change the formula in YTD plan column that calculates YTD
plan (if C2<>"",d2,0) as usual but total all above if data in column B
(month) are not blank or if right A7,5="total".
In the month column (it is a pivot table) data are not the same for all
records.
So I need add to my formula "sum all above" if certain conditions met.
Is it possible?
I have the following data
customer month actual costs monthly plan ytd plan
A 1 1 2 2
2 3 2 2
3 2
4 2
A Total sum of all above
The formula for YTD Plan is = if actual costs(C2) is not blank then monthly
plan (D2) =if C2<>"",d2,0
I woud like to change the formula in YTD plan column that calculates YTD
plan (if C2<>"",d2,0) as usual but total all above if data in column B
(month) are not blank or if right A7,5="total".
In the month column (it is a pivot table) data are not the same for all
records.
So I need add to my formula "sum all above" if certain conditions met.
Is it possible?