See the screenshot below. What function can be used in cell G3 (and then copied
ID: 3252031 • Letter: S
Question
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.
=SUBTOTAL(9,Units_Sold,Month,G$2,Name,$F3)
=SUBTOTAL(9,Units_Sold,Month=G$2,Name=$F3)
=SUMIF(Month,G$2,Name,$F3,Units_Sold)
=SUMIF(Month=G$2,Name=$F3,Units_Sold)
=SUMIFS(Units_Sold,Month,G$2,Name,$F3)
=SUMIFS(Units_Sold,Month=G$2,Name=$F3)
=AUTOSUM(Units_Sold,Month,G$2,Name,$F3)
=AUTOSUM (Units_Sold,Month=G$2,Name=$F3)
Month Units sold 2 Jake J Jake 4 Eric 5 Jake Bruce 7 Bruce 119 John Alex April 1 John Jan Feb March April May JuneExplanation / Answer
index and match function will be used
={INDEX(C2:C14,MATCH(F3&G2,A2:A14&B2:B14,0))}