Need assistance building an excel model as noted below:

Please show excel formulas and/or functions, thank you.

H 1 A B DE F Build a model that populates the table below. Assume that no transactions will be added or deleted from the list but the data about the transactions may change and the 3 counts should update in response to these changes. 2 4 5 Average sales (dollars) of makeup products (excluding returns) by weekday: 6 1 2 3 4 5 6 7 7 Mon Tue Wed Thu Fri Sat Sun 8 eye liner 9 foundation 10 lip gloss 11 lipstick 12 mascara 13 14 Returns can be identified as rows with negative units 15 Adding a calculated column with weekdays can help 16 It is okay for your output cells to show errors when you remove data from input cells. 17 18 Trans Nur Name Date Product Units Dollars 19 1 Betsy 5/1/2018 lip gloss 45 $137.20 20 2 Hallagan 4/10/2018 foundatio 50 $ 152.01 21 3 Ashley 3/25/2019 lipstick 9 $ 28.72 22 4 Hallagan 6/22/2020 lip gloss 55 $ 167.08 23 5 Zaret 7/17/2018 lip gloss 43 $ 130.60 24 6 Colleen 12/27/2019 eye liner 58 $ 175.99 25 7 Cristina 4/21/2018 eye liner 8 $ 25.80 26 8 Colleen 1/17/2021 lip gloss 72 $ 217.84 27 9 Ashley 8/5/2020 eye liner 75 $ 226.64 28 10 Betsy 9/7/2020 lip gloss 24 $ 73.50 29 11 Ashley 12/29/2018 mascara 43 $ 130.84 30 12 Ashley 12/18/2018 lip gloss 23 $ 71.03 31 13 Emilee 10/1/2019 lip gloss 49 $ 149.59 32 14 Hallagan 2/1/2019 eye liner 18 $ 56.47 33 15 Zaret 10/20/2020 foundatio -8 $ (21.99) 34 16 Emilee 5/12/2018 mascara 45 $ 137.39 35 17 Colleen 5/30/2020 mascara 66 $ 199.65 36 18 Jen 10/1/2019 lip gloss 88 $ 265.19 37 19 Jen 11/27/2018 eye liner 78 $ 236.15 38 20 Zaret 12/27/2019 lip gloss 57 $ 173.12