Enter an Excel formula using the COUNTIF() function in cells F8-F19 that will compute the "Number of Quarters among Top 3" for each Salesperson. Your COUNTIF function should count the number of occurrences of the text string "Yes" in found in the Qtr_1, Qtr_2, Qtr_3, and Qtr_4 columns for each salesperson.

\ The data in these columns will be "Yes" if a salesperson's sales was among the Top 3 for that quarter and "No" if the salesperson was not. For example, if the salesperson in cell A8 (which should be your name) was among the Top 3 salespersons in Quarter 1, then cell B8 would contain the word "Yes"; otherwise B8 would contain word "No".

X AutoSave . Off) H CA2_sales - Excel Search Albkeirat, Sammy - (sammya) AS File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri v 11 A" A ap Wrap Text General AP O Fill Paste Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity BIU~ ~ DAY Merge & Center $ ~ % " Formatting * Table Styles v v Clear Filter ~ Select Data Font Alignment Number Styles Cells Editing Analysis Sensitivity Clipboard C24 X Y fx B C D E F G H K M N O P A Salesperson Qtr_1 Qtr_2 Qtr_3 Qtr_4 Total Sales Above Average Total Sales Bonus 7 Y 8 Sammy Albkeirat $29,550.91 $28,801.82 $30,384.45 $29,661.82 $118,399.00 $0.00 $0.00 9 Dawson Williamson $38,091.00 $31,927.00 $36,136.00 $38,748.00 $144,902.00 $144,902.00 $ 7,245.10 10 Everett Rollins $21,931.00 $23,237.00 $18,135.00 $20,673.00 $83,976.00 $0.00 $0.00 11 Jessica Chaney $30,547.00 $23,269.00 $27,478.00 $25,905.00 $107,199.00 $0.00 $0.00 12 Gustavo Petersen $26,632.00 $32,768.00 $33,824.00 $37,180.00 $130,404.00 $130,404.00 $6,520.20 13 Rosalie Tucker $24,370.00 $34,308.00 $27,929.00 $24,949.00 $111,556.00 $0.00 $0.00 14 Holden Myers $41,151.00 $36,607.00 $43,167.00 $35,119.00 $156,044.00 $156,044.00 $7,802.20 15 Jaylen Hubbard $18,125.00 $20,124.00 $21,198.00 $21,426.00 $80,873.00 $0.00 $0.00 16 Rylee Kelley $33,052.00 $27,156.00 $31,944.00 $29,438.00 $121,590.00 $121,590.00 $6,079.50 17 Asher Hoover $34,526.00 $30,948.00 $34,620.00 $32,887.00 $132,981.00 $132,981.00 $6,649.05 18 Delaney Kent $24,341.00 $24,533.00 $28,471.00 $22,675.00 $100,020.00 $0.00 $0.00 19 Kira Mills $32,294.00 $31,943.00 $31,327.00 $37,280.00 $132,844.00 $132,844.00 $6,642.20 20 21 22 23 24 25 26 27 28 29 Scenario_1 Scenario_2 Sales | Salespersons + - + 110% O 85% AC E 1 7 ENG 7:11 PM Type here to search 3/12/2021