Quote:
Originally Posted by barexcel
Q1 Answer: I want the SUMIFS formula to always calculate, so I referenced the Criteria range1 to the Criteria1.
|
Not sure I still understand why you would reference D1. The sumifs will always calculate, D1 is not neccessary, and furthermore, makes no sense in the formula.
Quote:
Originally Posted by barexcel
Q2 Answer:What I was hoping to see is the percent being supported. For example 100%, or 50%.
|
How about some logic? For 7/1/2016, what do you expect, 50% or 100% and why? I see for 7/1/2016 it shows 15% on row 18.
What do you get from knowing that 15%?