Question

1 Approved Answer

Posted on Sep 11, 2024

6. Nadia also needs to calculate the total sales for marketing plans and the average sales for clients in New Jersey In cell N20, create

6. Nadia also needs to calculate the total sales for marketing plans and the average sales for clients in New Jersey In cell N20, create a formula using the DSUM function to calculate the total sales for marketing plans, using the data in the entire Sales table (Sales[#All]) and totaling the values in the Total Sales column ("Total Sales") for services equal to the values in the range M18:M19. 7. In cell N24, create a formula using the DAVERAGE function to calculate the average sales for clients in New Jersey, using the data in the entire Sales table (Sales[#All]) and averaging the values in the Total Sales column ("Total Sales") for clients in states equal to the values in the range M22:M23 $ NY Free 2 Soi 3 Soreica Client Cut Seat Start D. Brandparitioning ASHBY Utilities GA 27572021 5 Brandparitioning CLAUS Technology NU 10/12/2021 6 Brandparitioning FLATH Healthcare GA 2/12/2021 2 Brandparitioning KERRA Energy NY 246/2021 Brandparitioning NEETN E Energy FL 3/8/2021 9 Brandparitioning RENOR Banking CT 975/2021 10 Brandorearch ASHBY Utilities GA 4112021 Brandraroarch CLAUS Technology NJ 1/21/2021 12 Brandrerearch KERRA Enerty 216/2021 Brandrerearch NEETN Energy FL 370/2021 Brandrerearch RENOR Banking 4720/2021 15 Digital marketing ASHBY UNiliter GA 8P15/2021 16 Digital marketing OLAUS Technology NJ 1/21/2021 17 Digital marketing HARRA Healthcare NJ 1/17/2021 Digital marketing LUOIO UR NY 372/2021 Digital marketing MIRSS Technology FL 2/25/2021 20 Digital marketing RENOR Barline CT 2/24/2021 21 Market arrorrment CLAUS Technoloxy NJ 1/21/2021 22 Harker FLATH Healthcare GA 271272021 Marketween KERRA Energy NY 5/17/2021 24 Marketarement LUOIO Utilities NY 3225/2020 Market Mrement MIRSS Technolony FL 212572021 26 Market arrement WELLS Banking NY 3/10/2021 27 Marketingplan ASHBY Utilities GA 575/2021 28 Marketingplan CLAUS Technology MJ 97072021 29 Marketing plan HARRA Healthcare 4/30/2021 30 Marketing plan LUCIO Utili HY 27172021 31 Marketingplan MIRSS Technalas TL 2/2572021 Marketinslor RENOR Banking OT 272472021 Tar marketing OLAUS Technolo H2 940/2021 34 Target marketing FLATH Health GA 1/24/2021 Target marketing HARRA Healthcare Ha 1/17/2021 34 Target marketin KERRA nay HY 9/2012021 1er marketin LUOIO Usilitie WY 2012021 30 Tasting HIRSS Tech FL 1/2021 HEETH Enary FL 272021 40 Tarsemakin REHOR Bambing OT 272472021 Qtr 1 Qtr 2 Qtra Qer Tatul Sala $ 3,985 $ 2,690 1,470 $ 1,590 $ 9,735 $ $ $ $ 8,755 $ 8,755 $ 5.675 $ 5,850 $ $ $ 11,525 $ 4,875 $ 4.065 $ $ $ 1,275 $ 2,095 $ $ 3,370 $ $ $ 4,590 $ 9,395 $ 9,95 $ $ 1275$ $ 2,260 $ 3,535 $ 2,450 $4,675 $ $ 2.165 10,290 > $ 2,070 $ $ 2.135 $ 2,450 $ 4.455 PF $ 5,465 $ 3.150 $ $ $ 9,315 $ $ 2,235 $ $ 4,015$ 5,250 $ $ 3,560$ 4,095 $ 7,655 KEF $ 5,0655 $ 5,065 $ 2,775$ 12,905 $ 3,255 $ 3,160 $3,450 $ 3,730 $ 13,595 $ 3.045 $ 2.190.$ 1,450 $ 1,035 $ 7,720 Sors $ 2,550 $ $4,775 $ $ Hark 1,975 5 2,170 3,055 $ 549 $ 10,705 Tatal $ 5,270 $3,025 $ 3.745 $2,750 $ 13.390 5,055 $ 5,055 $ 5.055 $ 5.055$ 20,220 State $ 1750 $ $ 4,275 $ 6,025 NJ $ $ 2,775 $ 4,075 $ 6,950 Avara 1,275 $ 1,275 $ $ 2,575 $ 5,125 2,245 $2,750 $ 2,750 $ 2,2455 9,990 $ $ 7.750 $ 3.240 $ 7.190 $ 10, $ $ 1,275 $ 950 $ $ 3,475 $ 7,950 5 4,575 $ 15,000 $4,565 $ 5 + 7.565 1,500 $ 4,95 1 1 11,450 $ 76 $2,400 1 1 10,075 $ 1 9.270 $ $ 1 2,540 $ 2,750 $ 5,240 S 416 1 3,765 1 $ 3,625 $ $ $ 7,050 $ 2,475 4,400 1 1 TS 0 2,040 1 $ 1 $3,575 $ 2,79 $ 730 55 $ 70 200 $ te 140 10,225 11 185 55 1525 , Banking $57,145 End: 7 51 Healthcare 75,255 $12,543 Technology $9,293 $69,115 3 3,585 ks, Team Project: Client ID KERRA Project: 55 9,315 : 55 15 55 13,390 20 220 6025 35g Service Marketingplan DESIA: Avoraqo Salor: 13.180