Sumproduct is returning irregular values
Your original test, this term: (Actuals!$A$2:$A$7500<"Q4")
was meaningless because "<" is an operator meant for numbers, not text. "Q4"
is text, and unfortunately, because of the way that Excel evaluates it as
clarified in my response, the results can be misleading. Just a parting
thought here for you.
|