if anyone can help me with the following formula i would be very gratefull

i'm doing a spreadsheet for a sheep draw, which involves 6 stock agents, who
have different numbers each week (eg as below)

Agent Number of Sheep No of Pens Req Pen
Numbers
1 2,000 49
1 to 49
2 3.000 74
50 to 123
3 3,000 74
this is the problem
4 3,000 74
i need to to omit
5 3,000 74
(116-124)
6 3,000 74

Total Yarding 17,000 ie 41 sheep per pen Total Pens 419

i need help with the formula for pen allocations. Pens 1-443 omitting
(116-124 & 153-167).

Thanks