Forum Discussion
SUMIFS MULTIPLE Criteria including between two numbers
Hello, I could really use some help with the formula below. I believer this issue is the last part of the formula that want a number between 0 and 35. I hope someone can assist. =SUM(SUMIFS(HX...
HansVogelaar It would like let me attach the file here and so I've sent it to you in a private message. Thank you for your time.
Thanks. When I rename the sheet in your sample workbook to HX, and enter the formula in another sheet, the result is not 0 but 1,000,000. This is because rows 4, 5, 8 and 9 meet the criteria (you forgot to mark row 5).
- HansVogelaar, yes I see that it does work on the small data set that I sent to you. Unfortunately it is still not working on my large data set. Thank you for your help.
If you wish you can send me an anonymized file that demonstrates the problem.
- HansVogelaar thanks so much for your help with this issue. We are re-evaluating the data to be sure that it is not corrupt. I will reach out if needed in the future.
Humbly,
Regina