Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Incremental SUM using multiple SUMIF criteria?

Posted on 2014-10-20
Medium Priority
208 Views
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
0
Question by:jmac001
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 27

Accepted Solution

Glenn Ray earned 2000 total points
ID: 40392731
Normally, I'm not one for gaming the system, but why not enter -1199.999 as the contingency?  It will display (\$1,200.00) and allow the formula to work.
0

Author Closing Comment

ID: 40392778
So simplex, didn't even think to add the cents when I was doing my example.  This is easy to explain to users  why it has to be done this way.  Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a serious pitfall that can happen when deleting shapes using VBA.