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...
Hi HansVogelaar, I probably did not say it clearly. I believe the issue is the last part of the formula where part is the calculation is between 0 and 35, HX!P:P, "13001",HX!EY:EY, ">0", HX!EY:EY, "<35"). The formula is currently returning a zero in each instance and this is incorrect. Thanks, =SUM(SUMIFS(HX!BB:BB, HX!DU:DU, "18", HX!Q:Q, "0735", HX!R:R, "91735", HX!P:P, "13001",HX!EY:EY, ">0", HX!EY:EY, "<35"),
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
