Please help with the following: How do I do a formula for the names when they have different last initials?

Use conditional formatting on the salaries in the range B$2$:B$17.$ In the "top$/$bottom rules," use "Below Average" and Light Red FIll Color with Dark Red Font. This should display the lowest values in Red.$$

In cell B$19$ calculate the combined salaries of all employees named Steve

In cell B$20$ calculate the combined salaries of all employees named Mary

In cell B$21$ calculate the combined salaries of all employees named Larry

In cell B$22$ calculate the combined salaries of all employees named Joe $($Joseph$,$also$)$

In cell B$23,$ calculate the AVERAGE salaries of all employees named Lisa