please help. $($on Excel$)$ Richardson Ski Racing $($RSR$)$ sells equipment needed for downhill ski racing. One of RSR$$s products is fencing used on downhill courses. The fence product comes in $150-$foot rolls and sells for $$215$ per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:

The file$$RSR$$contains $172$ orders that have arrived for the coming six weeks.

a$.$Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.

b$.$Use the COUNTIF function to determine the number of orders in each price bin.