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

$

$119635$

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

From To Price per Roll Number Orders

$1100$ $$215$

$101200$ $$195$

$201400$ $$175$

$401$ and up $$155$

$172$