B$26$

X

A

C

D

F

G

H

K

L

M

N

P

$1$

$2$ Product

$3$ From:

Product $4$

Feb

Question #$1($Part A$)-$ Create a function using match, index and offset to sum the total of the revenue for each product given a set range.

$*$Assume the user will always correctly enter a from month before the to month

Apr

Total

$67$

Product

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$8$ Product $1$

$106$

$174$

$114$

$92$

$167$

$149$

$174$

$107$

$145$

$177$

$142$

$153$

$9$ Product $2$

$181$

$135$

$133$

$170$

$153$

$90$

$129$

$124$

$165$

$135$

$155$

$171$

$10$ Product $3$

$116$

$150$

$166$

$167$

$164$

$141$

$176$

$117$

$141$

$108$

$155$

$164$

$11$

Product $4$

$111$

$161$

$184$

$139$

$181$

$149$

$145$

$115$

$167$

$160$

$117$

$129$

$12$ Product $5$

$186$

$156$

$135$

$136$

$145$

$183$

$178$

$160$

$148$

$150$

$166$

$131$

$13$

$14$

$15$

$16$

$17$