Solved

Incremental SUM using multiple SUMIF criteria?

Posted on 2014-10-20
2
202 Views
Last Modified: 2014-10-20
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
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 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

by:jmac001
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question