Assignment

$($a$)$ Use the XLOOKUP 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.

From

To

Price per Roll

Number of

Orders

$\backslash$table$[[1,50,$$$215,],[51,100,$$$195,],[101,200,$$$175,],[201,$and up$,$$$155,172]]$