Hi All,
I'm trying to do a sum formula along row 17, if the dates in column F are less than the date in C2. Weirdly, this formula results in the incorrect answer, but interestingly enough, if I divide the answer the formula gives by 3, it then results in the correct answer, and this holds for all values along row 17 (J17:N17, O17, P17, etc....)
But before I just divide by 3 and call it a day, I am wondering if somebody would be able to tell me a) why this is happening, and b) if there is an actual formula that delivers the correct answer, rather than having to do this post-formula machination.
Thank you so much for any help!
=SUMPRODUCT((F27:F30<C2)*(J17:M17))
I'm trying to do a sum formula along row 17, if the dates in column F are less than the date in C2. Weirdly, this formula results in the incorrect answer, but interestingly enough, if I divide the answer the formula gives by 3, it then results in the correct answer, and this holds for all values along row 17 (J17:N17, O17, P17, etc....)
But before I just divide by 3 and call it a day, I am wondering if somebody would be able to tell me a) why this is happening, and b) if there is an actual formula that delivers the correct answer, rather than having to do this post-formula machination.
Thank you so much for any help!
=SUMPRODUCT((F27:F30<C2)*(J17:M17))