I'm trying to solve the below written formula:
=SUMIFS(AE9:AE17,S8:S17,">=1.0",S8:S17,"<=1.15")it returns #VALUE! Error.
AE9:AE17 is the sum range
I couldn't find the solution online. Anyone out there can help?
12 Answers
Make sure the sum range and the criteria range in formula are the same.
Your Formula should be written like this:
=SUMIFS(AE9:AE17,S9:S17,">=1.0",S9:S17,"<=1.15")Note: The problem with your formula was Mismatch of SUM & CRITERIA range, as mentioned by Lee also.
