I need to know what formula is needed to solve the total number of returned lip gloss and number of transactions sold by jen or ashley, using the sumif(s) function
I need to know what formula is needed to solve the total number of returned lip gloss and number of transactions sold by jen or ashley, using the sumif(s) function
Elementary Geometry for College Students
6th Edition
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Daniel C. Alexander, Geralyn M. Koeberlein
ChapterA: Appendices
SectionA.1: Algebraic Expressions
Problem 2E
Related questions
Question
I need to know what formula is needed to solve the total number of returned lip gloss and number of transactions sold by jen or ashley, using the sumif(s)
![0
Trace Precedents
Trace Dependents
p & Math & More
Name
mce Trig Functions Manager Create from Selection Remove Arrows-
Defined Names
D
1
2
B
D
4
4
D
4
3
9
9
3
5
9
5
2
B
1
1
2
4
eet1
G
***
H
Q3. Hospital
Paste range names below:
Date
Dollars
Name
Product
Define Name -
Use in Formula-
Units
(2 seperate criteras) Number of transactions sold by Jen or Ashley
Average units foundation sold per transaction by Zaret when units more than 10
Sheet2
Transaction=Q1. Makeup-IFS'ISA SA
=Q1. Makeup-IFS'ISE SE
12
Use SUMIF(s), COUNTIF(s), AVERAGEIF(s) to obtain the following informaiton.
Requirement:
1. Give the names for each data column
2. Use the range names in your formula
3. Paste the range names
=Q1. Makeup-IFS'I$C:$C
Q1. Makeup-IFS'ISF:SF
Q1. Makeup-IFS'I$8.$B
Q1. Makeup-IFS'ISD:$D
K
+
799
Formula Auditing
M
Show Formulas
Error Checking
Evaluate Formula
Revenue of mascara $51,893.08
Total number of returned lip gloss
N
T
53.475
0
69
Watch Ca
Window a
P
Desktop OneDrive](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F556d7f69-fc06-4b64-8f8e-9d929a29fe26%2F49309099-4c9d-436b-8588-93f1063de0e0%2Fn0al9n_processed.png&w=3840&q=75)
Transcribed Image Text:0
Trace Precedents
Trace Dependents
p & Math & More
Name
mce Trig Functions Manager Create from Selection Remove Arrows-
Defined Names
D
1
2
B
D
4
4
D
4
3
9
9
3
5
9
5
2
B
1
1
2
4
eet1
G
***
H
Q3. Hospital
Paste range names below:
Date
Dollars
Name
Product
Define Name -
Use in Formula-
Units
(2 seperate criteras) Number of transactions sold by Jen or Ashley
Average units foundation sold per transaction by Zaret when units more than 10
Sheet2
Transaction=Q1. Makeup-IFS'ISA SA
=Q1. Makeup-IFS'ISE SE
12
Use SUMIF(s), COUNTIF(s), AVERAGEIF(s) to obtain the following informaiton.
Requirement:
1. Give the names for each data column
2. Use the range names in your formula
3. Paste the range names
=Q1. Makeup-IFS'I$C:$C
Q1. Makeup-IFS'ISF:SF
Q1. Makeup-IFS'I$8.$B
Q1. Makeup-IFS'ISD:$D
K
+
799
Formula Auditing
M
Show Formulas
Error Checking
Evaluate Formula
Revenue of mascara $51,893.08
Total number of returned lip gloss
N
T
53.475
0
69
Watch Ca
Window a
P
Desktop OneDrive
![Function
L15
A
1 Trans #
23
4
5
6
7
8
9
10
11
12
13
14
15
56
16
17
11272822&
19
20
23
24
25
26
READY
E
B
Name
1 Betsy
2 Hallagan
3 Ashley
4 Hallagan
5 Zaret
Used
6 Colleen
7 Cristina
8 Colleen
9 Ashley
10 Betsy
11 Ashley
12 Ashley
13 Emilee
14 Hallagan
15 Zaret
16 Emilee
17 Colleen
18 Jen
19 Jen
20 Zaret
21 Zaret
22 Betsy
23 Colleen
24 Hallagan
25 Jen
X✓ fix
C
Date
Function Library
4/1/2013 lip gloss
3/10/2013 foundation
2/25/2014 lipstick
5/22/2015 lip gloss
6/17/2013 lip gloss
11/27/2014 eye liner
3/21/2013 eye liner
12/17/2015 lip gloss
7/5/2015 eye liner
8/7/2015 lip gloss
11/29/2013 mascara
11/18/2013 lip gloss
8/31/2014 lip gloss
1/1/2014 eye liner
9/20/2015 foundation
4/12/2013 mascara
4/30/2015 mascara
8/31/2014 lip gloss
10/27/2013 eye liner
11/27/2014 lip gloss
6/2/2015 mascara
Q1. Makeup-IFS
D
E
Product Units
9/24/2013 eye liner
2/1/2015 mascara
5/2/2014 foundation.
11/7/2013 mascara
Type here to search
Time Reference Trig F
45 $137.20
50 $152.01
$28.72
9
55 $167.08
43 $130.60
58
$175.99
$25.80
8
72 $217.84
75 $226.64
F
Dollars
24 $73.50
43 $130.84
23 $71.03
49 $149.59
18
$56.47
-8
-$21.99
45 $137.39
66 $199.65
88 $265.19
78 $236.15
57 $173.12
12
$38.08
$86.51
$77.31
$88.22
-$9.94
28
25
29
-4
Q2. Makeup-Pivot
Sheet1
G
Use S
Requi
1. Giv
2. Us
3. Pa
Avera
Q3. Hos](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F556d7f69-fc06-4b64-8f8e-9d929a29fe26%2F49309099-4c9d-436b-8588-93f1063de0e0%2Fb0ydaz_processed.png&w=3840&q=75)
Transcribed Image Text:Function
L15
A
1 Trans #
23
4
5
6
7
8
9
10
11
12
13
14
15
56
16
17
11272822&
19
20
23
24
25
26
READY
E
B
Name
1 Betsy
2 Hallagan
3 Ashley
4 Hallagan
5 Zaret
Used
6 Colleen
7 Cristina
8 Colleen
9 Ashley
10 Betsy
11 Ashley
12 Ashley
13 Emilee
14 Hallagan
15 Zaret
16 Emilee
17 Colleen
18 Jen
19 Jen
20 Zaret
21 Zaret
22 Betsy
23 Colleen
24 Hallagan
25 Jen
X✓ fix
C
Date
Function Library
4/1/2013 lip gloss
3/10/2013 foundation
2/25/2014 lipstick
5/22/2015 lip gloss
6/17/2013 lip gloss
11/27/2014 eye liner
3/21/2013 eye liner
12/17/2015 lip gloss
7/5/2015 eye liner
8/7/2015 lip gloss
11/29/2013 mascara
11/18/2013 lip gloss
8/31/2014 lip gloss
1/1/2014 eye liner
9/20/2015 foundation
4/12/2013 mascara
4/30/2015 mascara
8/31/2014 lip gloss
10/27/2013 eye liner
11/27/2014 lip gloss
6/2/2015 mascara
Q1. Makeup-IFS
D
E
Product Units
9/24/2013 eye liner
2/1/2015 mascara
5/2/2014 foundation.
11/7/2013 mascara
Type here to search
Time Reference Trig F
45 $137.20
50 $152.01
$28.72
9
55 $167.08
43 $130.60
58
$175.99
$25.80
8
72 $217.84
75 $226.64
F
Dollars
24 $73.50
43 $130.84
23 $71.03
49 $149.59
18
$56.47
-8
-$21.99
45 $137.39
66 $199.65
88 $265.19
78 $236.15
57 $173.12
12
$38.08
$86.51
$77.31
$88.22
-$9.94
28
25
29
-4
Q2. Makeup-Pivot
Sheet1
G
Use S
Requi
1. Giv
2. Us
3. Pa
Avera
Q3. Hos
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Elementary Geometry for College Students](https://www.bartleby.com/isbn_cover_images/9781285195698/9781285195698_smallCoverImage.gif)
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning
![Elementary Geometry for College Students](https://www.bartleby.com/isbn_cover_images/9781285195698/9781285195698_smallCoverImage.gif)
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning