Excel SUMIF criteria within range of numbers
<p>I was wondering how to represent the criteria argument in the function =SUMIF(range, criteria) as instead of ">0" which represent greater than zero, which would add all numbers in the range that are greater than zero. I was wondering how to make it within the range of zero to 8, so "8>0", or something, but I have been googling for hours and cannot find a solution that doesn't involve doing whacky things with SUMIFS which involves other arrays which I do NOT want to get into because I feel there's a simple solution to this that I'm missing...
Theres ">=NUM" "&lt;=NUM" ">NUM" and "&lt;.NUM"
how do you make it require two of these?
Is there any documentation on this anywhere?
<a href="https://i.stack.imgur.com/5ASBe.png" rel="nofollow"><img src="https://i.stack.imgur.com/5ASBe.png" alt="enter image description here"></a></p>