Use the SUMIF function to complete the "Total Pay" column in table 3. Reference the "Employee" field in table 1 as your range, the "Employee" names in table 3 as your criteria, and the "Total Pay" field in table 1 as your sum_range.