I want to reference a named range "Week3" for my sum_range, like the formula in cells Scorecard!E5:E7... but these formulas return a #VALUE! error. I don't want to key the named range into my formulas, like in cells Scorecard!C5:D7.
Incorrect formula: =SUMIFS(E$2,Site,$B5,Metric,"units")/SUMIFS(E$2,Site,$B5,Metric,"Hours")
How can this be corrected?
Bookmarks