B28 XVfx A B C D E F G H DAILY SALES DATE STORE#1 STORE#2 STORE#3 STORE#4 STORE#5 2019/7/11 $19, 025 $10,423 $19,282 $12 , 689 $19, 069 2019/7/12 $16,270 $19, 602 $17, 735 $17 , 756 $15, 044 2019/7/13 $10, 480 $10, 104 $14,988 $16, 894 $19, 456 2019/7/14 $16, 559 $12 , 104 $12 , 982 $18, 897 $14, 331 2019/7/15 $10, 619 $12 , 405 no data $18,919 $18, 063 2019/7/16 $14, 045 $10, 574 $10, 517 $11, 281 $17 , 430 2019/7/17 $11, 948 $10, 563 $11, 011 $15, 196 $11, 947 10 2019/7/18 $12, 122 $11, 992 $15, 403 $18, 286 $18, 902 2019/7/19 $13, 420 no data $16, 721 $12 , 839 $18, 428 2019/7/20 $14, 138 $19,437 $13, 579 $12 , 536 $14, 034 13 2019/7/21 $14, 837 $17 , 441 $16, 508 $10,966 $18, 573 14 2019/7/22 no data $15, 573 $14,565 $15,950 $16, 008 15 2019/7/23 $17 , 457 $11, 087 $11, 616 $10, 683 $13, 668 16 2019/7/24 $11, 087 $17,289 $12 , 328 $19,799 $15, 158 17 18 STORE#1 STORE#2 STORE#3 STORE#4 STORE#5 19 TOTAL: $182 , 007 $178 , 593 $187,235 $212 , 692 $230, 113 20 AVERAGE : $14, 001 $13, 738 $14, 403 $15, 192 $16, 437 21 MIN: $10, 480 $10, 104 $10, 517 $10, 683 $11,947 22 MAX: $19, 025 $19, 602 $19,282 $19,799 $19,456 23 GRAND TOTAL: $990 , 640 24 You can use the rest of this worksheet to calculate these values. You will need to use 25 the WEEKDAY() function to break-out the data needed for this portion. 26 Mondays Tuesdays Wednesdays Thursdays Fridays 27 TOTAL: 28 RANK: 29