Answered step by step
Verified Expert Solution
Question
1 Approved Answer
See the screenshot below. What function can be used in cell G3 (and then copied through the range G3:L9) to summarize the total number of
See the screenshot below. What function can be used in cell G3 (and then copied through the range G3:L9) to summarize the total number of units sold by month and salesperson? Assume that the three columns of the dataset have been named Name, Month, and Units_Sold. O ESUBTOTAL(9,Units_Sold, Month, G$2.Name, SF3) O ESUBTOTAL(9,Units_Sold, Month=G$2,Name=$F3) O ESUMIF(Month, G$2,Name SF3, Units_Sold) O =SUMIF(Month=G$2,Name=SF3, Units_Sold) O =SUMIFS(Units_Sold, Month, G$2.Name, SF3) O ESUMIFS(Units_Sold, Month=G$2,Name=$F3) O=AUTOSUM(Units_Sold, Month, G$2,Name, $F3) O=AUTOSUM (Units_Sold, Month=G$2,Name=$F3) Name Month Units sold Man Feb March April May June March June March 7 Bruce ohn 9 John 10 Alex 11 John June April May June March March 13 John 14 John
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