jmac001
asked on
Incremental SUM using multiple SUMIF criteria?
Hi Experts,
I am looking for the best way to get the results I need. On the attached workbook in the area that is labeled with Level 1... Level 6 I am trying to add when there is an increase or decrease at each of the phases and each phase is at 0 until there is data populated in the Drivers area. The data is broken into feasibility + 4 phases (columns) with 7 categories (rows). The SUMIF formulas are working but I found a new issue and I am not sure how to account for it.
Looking at tab 101 if the sum of column H (by phase) is 0 then only the amounts that are inserted in column H is populate in the phase above (SD).
Tab 099 is how I would like the calculation to work if Professional Fees shows that there is an increase by 1200 and the Contingency lines shows that it was decreased by 1200.
PPTT-2014.10.20-q2.xlsm
I am looking for the best way to get the results I need. On the attached workbook in the area that is labeled with Level 1... Level 6 I am trying to add when there is an increase or decrease at each of the phases and each phase is at 0 until there is data populated in the Drivers area. The data is broken into feasibility + 4 phases (columns) with 7 categories (rows). The SUMIF formulas are working but I found a new issue and I am not sure how to account for it.
Looking at tab 101 if the sum of column H (by phase) is 0 then only the amounts that are inserted in column H is populate in the phase above (SD).
Tab 099 is how I would like the calculation to work if Professional Fees shows that there is an increase by 1200 and the Contingency lines shows that it was decreased by 1200.
PPTT-2014.10.20-q2.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER