please help with the formulas

- A few functions you will need to insert in completing this assignment: addition SUMIF = is a range of cells that you want evaluated by criteria. The criteria can be described in the form of a number, expression or text that defines which cells will be added. For example, criteria can be expressed as 32,"32", ">32", or even "apples". AVERAGEIF = is the range of cells that you want to average Cells in range must contain numbers, name array, or cell reference that contain numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/O! Error-value! If the cell in criteria is empty..it will return a zero value. COUNTIF = is known for range.criteria Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. Examples: =COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) =COUNTIF (A2:A5, A4) Number of cells with peaches in the first column above (1) =COUNTIF(A2:A5,A3)+COUNTIF Number of cells with (A2:A5,A2) oranges or apples in the first column above (3) Quarties Quartiles Total Sales 564,103 1,154,422 2.064,113 YOUR NAME Date Function Summary Statistics Intro Intro-General Total Sales $ 17,376,251 S 11.198,548 Averages 1,489,588 $ 2,239,710 12 altion Book Title Contemporary Sociology Interpretations in Grief and Loss Bridging the Gap in facial Groups Sociology An Introduction Rank 1 2 3 4 5 6 7 SUNIF Research 8 10 8 5 1 8 Function is focal poche Discipline Area Introductory General Aging/Death Death and Dying Race/Class/Gender Race/Ethnicity Introductory General Research/Stats Research Methods Research/stats Social Statistics Race/Clas/Gender Gender ses Social Psychology General introductory General Criminal Justice Deviance Social Psychology General Research/Stats Social Statistics Agine/Death Death and Dying Social Psychology Symbolic Interactionism Family Family Interaction Social Problems General Research/Stats Research Methods Introductory Social Sciences Race/Clan/Gender Genderes Race/class/Gender Race/Ethnicity Race Class/Gender Gender les Research Stats Research Methods Criminal Justice Deviance Introductory Social Sciences Social Problems Violence/Abuse Race/Class/Gender Mumtan Sexuality Social Psychology General Required in An Introduction to Symbolike ctionism Behavioral and Social Scie statistics Death in Society Symbolic interact An Introduction Ses Total Book *holesale Retail Sales 3,740,000 130,000 $3,870,000 $ 3.564.00 187,1875 3.751,167 $ 3.218,7 $ 201,1425 3.419,899 5 3,055 294,500 $ 3.346, $ 3,0 755 226,6885 3,243 54875 202.9355 3.10 5 173,7505 169.000 5.750 S880455 127,950 $ 15,995 2,724,777 S 79,335 804112 2.512,500 5 280,849 2,793,349 $ 2,531,2505 180.00 2,711.298 $ 2.569.6755 1092679,475 $ 2.625.0005 2,641.851 $ 2,368,7505 S 2.638,352 $ 2 $ 2,388,642 52 RANKAVG S 2,352,200 $ 2 Function is $2.351.660 $ 2 $ 2,316,8% 52 Required in S 2.314,992 52 Column $ 2,164,250 52 $ 2,083.950 $ 1.927.500 5 130,000 $2.057.500 $ 1,850,000 169,000 5 2,025.000 $ 2017,6205 5.265 $ 2.022.885 $ 1,998,6205 18.5905 2017,210 $ 1,504,550 $ 133,200 $ 1937.750 $ 1822,0655 89,050 $ 1,911,115 9 10 11 12 13 14 15 16 17 AVERAGEIF COUNTIF Reser Function is Function is Science Required in and Wome Required in Cell F4 & 64 and the Cell F5 & 65 Gender Qualitative Research for Social Sciences Deviant Behavior 1 Introduction to Social Sciences Increasing Violence in Our Schools 2 Human Sexuality $ Social Psychology 3 19 20 21 22 23 24 25 26 27 2 Quar WARNA Say Statistics NG ARE Tuk 21.40 Apa ha www News Sa Social SA 2 12 S 19 - 2. 11 . Solo mal R. As al| Dud Sociolche who 1 - IND 2 Seul R. th By Ty C Mile Aethi 17. . 23 2. Swal 7. Rachan Waves Karo . D + you CD Sasa VA RaceCheck Social M Social FC Galers Aarthat Maria Secul title tra 21. 12 + US Lily . UN 23 De H Mandal Na Saw w Aaliya Spss the Image AS Www A. pe LO 2003 Excel 1 . S. - TU A Selo S Kwa C w 13 17 CA Apa Sacalm Ah Me NAS TA Sec BRON 2:41 Socials Social th w 47 AM Secull Koch thway HS De IL 33 20 ht D A RS AD Socio Cou By Fly Se IT 5.50 . ST AG MA 20 21 21:40 1 1 How Ah Sockel Seculo Cha unden SA LES DAW Seco Mara Ah Aur Dut Le 13 RI KAT C SP A Sustalu 3 HT Serial sales and D These GS A The 212 11211 M Social LI