Question: Please help me complete this excel question: B 2 6 table [ [ Product , Product 4 ] , [ From: , Feb ]

Please help me complete this excel question:
B26
\table[[Product,Product 4],[From:,Feb],[To:,Apr],[Total,]]
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
\table[[Product,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec],[Product 1,106,174,114,92,167,149,174,107,145,177,142,153],[Product 2,181,135,133,170,153,90,129,124,165,135,155,171],[Product 3,116,150,166,167,164,141,176,117.,141.,108,155,164],[Product 4,111,161,184,139,181,149,145,115,167,160,117,129],[Product 5,186,156,135,136,145,183,178,160,148,150,166,131]]
 Please help me complete this excel question: B26 \table[[Product,Product 4],[From:,Feb],[To:,Apr],[Total,]] Question

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!