Quote:
Originally Posted by jeffreybrown
Maybe you should explain why you reference John Doe (D1) in the sumifs when I can't see any correlation!
Also, how about giving some examples of what you would expect in R9, R10 etc?
|
Q1 Answer: I want the SUMIFS formula to always calculate, so I referenced the Criteria range1 to the Criteria1.
Q2 Answer:What I was hoping to see is the percent being supported. For example 100%, or 50%.