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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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)
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
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
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
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman