Hello I have this code and I want to force the sum of the numbers generated in the array to be between a certain number range e.g >=111 <=170.
I have tried this formula in the cellPlease Login or Register to view this content.
=IF(SUMIF(B6:G6,">=111, <=170")=0,"",SUMIF(B6:G6,">=111, <=170")), but all it gives me is a zero regardless of the number being between 111 and 170
Thank you for your help
Bookmarks