Originally Posted by
davsth
That is the minimum of your formula and 48
=min(your formula, 48)
=MIN(SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)=6)*(OFFSET($A8,0,31*($A$3-1)+1,1,31)))+SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)=5)*(OFFSET($A8,0,31*($A$3-1)+1,1,31))),48)
however your sheets does not contain any data, so does not show the problem you are having and so doesn't point people how to fix it. If you had shown the problem, with the answer say of 60 in your formula and said you wanted it to never be above 48 you would have got a quicker answer, the same holds for the other parts of your question you are asking. You more effort you put in in the question the quicker you get an answer. Glen is much smarter than me, but if both of us were confused, I am sure others were.
I would suggest some manual answers for your second 2 questions, with some dummy data, will expedite a quicker result.
Bookmarks