Question
table[[Product,Jan,Mar,Apr,M,,,],[car,128,50,107,86,54,86,89],[plane,75,90,139,90,146,88,133],[train,124,146,130,117,144,111,122],[car,135,84,127,61,102,109,127],[car,138,88,92,63,119,60,92],[plane,95,60,113,87,138,119,134],[car,104,74,84,126,125,110,77],[train,111,115,146,116,106,71,91],[car,89,106,82,99,86,111,114]] Write a formula that gives the total sales of that product during the given month hint: use sumif, offset, and match This is a
\\\\table[[Product,Jan,Mar,Apr,M,,,],[car,128,50,107,86,54,86,89],[plane,75,90,139,90,146,88,133],[train,124,146,130,117,144,111,122],[car,135,84,127,61,102,109,127],[car,138,88,92,63,119,60,92],[plane,95,60,113,87,138,119,134],[car,104,74,84,126,125,110,77],[train,111,115,146,116,106,71,91],[car,89,106,82,99,86,111,114]]\ Write a formula that gives the total sales of that product during the given month hint: use sumif, offset, and match\ This is a difficult question, please try your best. Remember: Start with a hard code function, and add other functions step by step.\ \\\\table[[Product,month,sales],[Car,May,],[train,Jan,],[plane,Mar,],[Car,Jul,]]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started