Homework Help is Here – Start Your Trial Now!
Math
Statistics
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
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
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer