w DO A B C D E F G 1 Play'em Again 2 Semiannual Sales 3 Products Mall Store Web Total Revenue Ranking Product Rating 4 Accessoroes 378,512.09 220,380.80 424,257.51 1,023,150.40 A Revenue Rating 5 Cell Phones 124,118.00 366,216.77 490,334.77 D 100,000.00 E 6 DVD's 109,971.82 21,209.46 131,181.28 E 250,000.00 D 7 Controllers 409,368.32 118,871.41 36,140.54 564,380.27 500,000.00 8 Games 413,265.32 112,511.16 525,776.48 750,000.00 B 9 iPads 149,327.59 358,232.57 337,465.90 845,026.06 B 1,000,000.00 A 10 Total 1,474,591.32 1,286,184.53 819,073.41 3,579,849.26 11 Average Sales 294,918.26 214,364.09 204,768.35 596,641.54 #DIV/0! 12 Maximum "web" based Revenue(Column D) 424,257.51 13 Minimim "Store" based Revenue (Column C) 109,971.82 14 Total Number of Products with Sale Revenue: 21 15 Total Number of Products with Blank Revenue: 3 16 17 Function Descriptions 18 =count(cell range) =sum(cell range) =average(cell range) 19 =countblank(cell range) =max(cell range) 20 Emin(cell range) =vlookup(lookup-value,table array,col_index) 21 22 Enter the correct function for cell D14 to calculate the total number of PRODUCTS with sale values