Quantity Ordered

From To Price per Roll

$130$ $$215$

$3160$ $$195$

$61120$ $$175$

$121$ and up $$155$

$($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.