I do not understand this AverageIF ref. Use the AVERAGEIF function to complete the "Average Hours/Job" column in table 4. Reference the appropriate field in table 1 as your range and the "Difficulty" rating in table 4 as your criteria.
Solved by S. D. in 22 mins