the price per roll depending on order size:

Quantity Ordered

$\backslash$table$[[$From$,$To$,$Price per Roll$],[1,100,$$$210],[101,150,$$$180],[151,250,$$$165],[251,$and up$,$$$150]]$

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 $($in dollars$)$ from these orders.

$$

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

Quantity Ordered

$\backslash$table$[[$From$,$To$,$Price per Roll,Number of Orders$],[1,100,$$$210,],[101,150,$$$180,],[151,250,$$$165,],[251,$and up$,$$$150,]]$