- How Much Revenue Was Made On Sales Transactions Involving At Least 50 Units Of Makeup 1 (100.45 KiB) Viewed 39 times
how much revenue was made on sales transactions involving at least 50 units of makeup?
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
how much revenue was made on sales transactions involving at least 50 units of makeup?
how much revenue was made on sales transactions involving at least 50 units of makeup?
File Paste Home Cut E Copy Insert Page Layout Arial BI U S x ✓ fxx Format Painter I Clipboard Font A Formulas Data 10 Α΄ Α A my. A S6 B 4 Name Dollar Volume 5 Emilee $ 6 Hallagan $ 7 Ashley $ 8 Zaret $ 9 Colleen $ 10 Cristina $ 11 Betsy $ 12 Jen $ 13 Cici $ 14 15 16 Units returned 17 Total dollars sold 2005 or later $ 18 Units of lip gloss sold 19 $s of lip gloss sold $ 20 $s sold not by Jen $ 21 Lipstick $s by Jen 22 avg units lipstick by Zaret 23 avg units lipstick Zaretunits >=5 24 Lipstick $s >= $100 Jen 25 Lipstick $s <$100 Jen 26 average units by Jen 27 28 29 ▼ S Review === View = €* 25,258.87 28,705.16 25,947.24 26,741.31 24,890.66 23,849.56 28,803.15 29,050.53 27,590.57 922 157,854.32 16333 49,834.64 211,786.51 3953 33 68 3583 370 check 43.548 Alignment с Help ab Wrap Text 43.548 Tell me what you want to do General $ %, Merge & Center D E S II E Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Cells G H I Trans Number Name 1 Betsy Hallagan 2 J K Date Product Units 4/1/2004 lip gloss 45 3/10/2004 foundation 50 Ashley 2/25/2005 lipstick 9 Hallagan 5/22/2006 lip gloss 55 Zaret 6/17/2004 lip gloss 43 3 4 5 6 7 8 9 10 Betsy 11 12 Ashley Ashley Emilee Hallagan 13 14 15 Colleen 11/27/2005 eye liner Cristina 3/21/2004 eye liner Colleen 12/17/2006 lip gloss Ashley 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundation 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara 5/2/2005 foundation 11/7/2004 mascara 16 17 18 19 Zaret Emilee Colleen Jen Jen Zaret Zaret Betsy Colleen Hallagan Jen 20 21 22 23 24 25 Number F +.0 .00 .0 S 5 45 5 L Dollars $137.20 $ 152.01 $28.72 $167.08 $130.60 58 $ 175.99 $ 25.80 72 $ 217.84 $ 226.64 $ 73.50 $ 130.84 $71.03 $ 149.59 $ 56.47 $ (21.99) $137.39 $199.65 $ 265.19 $ 236.15 $ 173.12 $38.08 $ 86.51 $ 77.31 $ 88.22 $ (9.94) 8 77 75 Σ Autosum - Αν A ✔Fill ✓Clear Sort Filte 75 24 43 23 49 18 -8 45 66 88 78 57 12 28 25 29 -4 Editing M
File Paste Home Cut E Copy Insert Page Layout Arial BI U S x ✓ fxx Format Painter I Clipboard Font A Formulas Data 10 Α΄ Α A my. A S6 B 4 Name Dollar Volume 5 Emilee $ 6 Hallagan $ 7 Ashley $ 8 Zaret $ 9 Colleen $ 10 Cristina $ 11 Betsy $ 12 Jen $ 13 Cici $ 14 15 16 Units returned 17 Total dollars sold 2005 or later $ 18 Units of lip gloss sold 19 $s of lip gloss sold $ 20 $s sold not by Jen $ 21 Lipstick $s by Jen 22 avg units lipstick by Zaret 23 avg units lipstick Zaretunits >=5 24 Lipstick $s >= $100 Jen 25 Lipstick $s <$100 Jen 26 average units by Jen 27 28 29 ▼ S Review === View = €* 25,258.87 28,705.16 25,947.24 26,741.31 24,890.66 23,849.56 28,803.15 29,050.53 27,590.57 922 157,854.32 16333 49,834.64 211,786.51 3953 33 68 3583 370 check 43.548 Alignment с Help ab Wrap Text 43.548 Tell me what you want to do General $ %, Merge & Center D E S II E Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Cells G H I Trans Number Name 1 Betsy Hallagan 2 J K Date Product Units 4/1/2004 lip gloss 45 3/10/2004 foundation 50 Ashley 2/25/2005 lipstick 9 Hallagan 5/22/2006 lip gloss 55 Zaret 6/17/2004 lip gloss 43 3 4 5 6 7 8 9 10 Betsy 11 12 Ashley Ashley Emilee Hallagan 13 14 15 Colleen 11/27/2005 eye liner Cristina 3/21/2004 eye liner Colleen 12/17/2006 lip gloss Ashley 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundation 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara 5/2/2005 foundation 11/7/2004 mascara 16 17 18 19 Zaret Emilee Colleen Jen Jen Zaret Zaret Betsy Colleen Hallagan Jen 20 21 22 23 24 25 Number F +.0 .00 .0 S 5 45 5 L Dollars $137.20 $ 152.01 $28.72 $167.08 $130.60 58 $ 175.99 $ 25.80 72 $ 217.84 $ 226.64 $ 73.50 $ 130.84 $71.03 $ 149.59 $ 56.47 $ (21.99) $137.39 $199.65 $ 265.19 $ 236.15 $ 173.12 $38.08 $ 86.51 $ 77.31 $ 88.22 $ (9.94) 8 77 75 Σ Autosum - Αν A ✔Fill ✓Clear Sort Filte 75 24 43 23 49 18 -8 45 66 88 78 57 12 28 25 29 -4 Editing M