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
icon
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) function

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: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
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
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman