Sumproduct is returning irregular values
Thanks Max. I did see that early and have changed my calculated values from
Q1, Q2 etc to 1, 2, 3 4 so that the equation will always work. I just kept
copying and pasting my original formula during the queries.
The replies in this forum are extremely helpful and educational!
--
Thanks
Marlaine
"Max" wrote:
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.
.
|