Dynamic range

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top