SUMIF returning #N/A-Function Argument returns FALSE when TRUE ???

Hi @Venkata Marella,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, the reason your formula returns false is because that Excel does not support chained comparisons. It doesn't treat the conditions "J2 > 3500 < 74600" as "J2 between 3500 and 74600" but evaluates from left to right.

For example, for J2 > 3500 < 74600, Excel evaluates first comparison J2 > 3500 and returns the results into TRUE/FALSE. Then it compares that to the next number and break the logic since it compares TRUE/FALSE to 74600 which will return FALSE.

If you want to combine two comparisons, you need to use the formula AND(). Instead of J2 > 3500 < 74600, the correct syntax should be AND(J2>3500, J2<74600). Excel will compare J2 value with both comparisons and will return TRUE if it meets all two conditions and FALSE if it doesn't meet at least ones.

I hope this helps you move forward smoothly. If you have more questions or need further clarification, feel free to leave a comment here and I’ll be happy to continue supporting you.

Thank you for your patience and understanding, and I look forward to assisting you further.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.