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 cell
Please 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
Last edited by UltimateNeo; 03-16-2019 at 08:14 PM.
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That gives 111 if the answer is 85 so only gives values between 111 and 170 it dose not force the code to run for rows that are not in the criteria.
When the code runs it will only accept rows that meet the criteria of being >=111 and <=170 .it should then re run but only on the rows that haven't met the criteria
For i = 6 To 30 for all these rows from 6 to 30 should be between >=111 and <=170 row 6 is B6:G6 and so forth until it gets to row B30:G30
Thank you for your help
Then maybeFormula:Please Login or Register to view this content.
But that would show true and false not the value between 111 and 170Originally Posted by TMS
Then maybeFormula:Please Login or Register to view this content.
Can you not work it out from there?
Formula:Please Login or Register to view this content.
I read this as you wanted numbers lower than 111 to be rounded up to 111 and numbers above 170 to be rounded down to 170.I want to force the sum of the numbers generated in the array to be between a certain number range e.g >=111 <=170
If I’m honest, I don't understand the description of how your code works, hence the second attempt.
Third time lucky?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks