Create an additional sheet e.g. RequestTypes with columns RequestType, Target.
Define the created table as Table (e.g. tRT), or define a dynamical named range (e.g. nRT) which includes datarange of created table.
As a bonus, you can define the data column of RequestType in tRT or 1st column of nRT as named range, and use this named range in your original table as Data Validation List source to select TypeOfRequest values.
Your formula OnTarget formula will be
in case you used defined Table:
Code:
=IF(OR($A2="",$B2=""),"",(SUMIF(tRT[Target],tRT[RequestType],$A2)>=$B2))
in case you used Named Range:
Code:
=IF(OR($A2="",$B2=""),"",(VLOOKUP($A2,nRT,2,0)>=$B2))
The formula returns TRUE when number of workdays is less or egual compared with target for reguest type, and FALSE when otherwise. When either TypeOfrequest or number of workdays remaind empty, an empty string is returned.
There is no limitations for target values - all requests may have same target, or every request type can have different target. It is up to you how you define them in RegustType sheet.