Thank you..vishwasexcel
Based Forum Rules
... How Your thread title reflects with You thread? ... please, reread Forum Rules
... is there any clear rules - how to figure?
thank you sirAnother shot in the dark...….
1] In C34, copied across and down :
=IF($B34="","",ROUND(MIN(MAX(VLOOKUP($B34,$Q$7:$T$10,3,0),VLOOKUP($B34,$B$23:$N$29,COLUMN(B1),0)),VLOOKUP($B34,$Q$7:$T$10,4,0))*VLOOKUP($B34,$Q$7:$T$10,2,0),0))
2] In C42, copied across :
=SUM(C34:C41)
3] In C43, copied across :
=VLOOKUP(C42,$C$51:$D$73,2,0)
View attachment 67744
Dear Sirvishwasexcel
Was Your reply ... as ... Thank you ... for my reply?
Thank You is many times okay,
but now - even that won't help You, vishwasexcel.