Using Excel's built-in Help, read up on the COUNTIF function.

Two ways it can be used a

- In an extra column(s) to report how many times a job is allocated.

- In conditional formatting to highlight jobs allocated too much (or
too little)

For a more specific suggestion, it'd help to know more about the data
layout.