Answer Happy

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