View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marlaine Marlaine is offline
external usenet poster
 
Posts: 9
Default 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.


.