Use Excel$$s SUM$()$ function and create formulas in Row $13$ to calculate total items sold

for each order source $$ retail, drive$-$thru, and delivery$/$online$.$

$2.$ Assign Cell$/$Range Names

a$.$ Assign cell names for the prices per unit and Cost of Goods Sold $($COGS$)$ for each

category.

i$.$ Example, use a range name such as A$\_$price for the avg price per unit for

category A items to use in subsequent formulas.

b$.$ Assign a Range name, Cat$\_$prices$\_$cogs, only including the price and GOGS values

for each category $($C$17$:E$20$ in current worksheet$)$