please help on #5 and 6. show work.

added

In cell H6, use an IF function with a nested AND function to create a function that analyzes the content of F6 and G6. Return Complete if both cells contain a Y or Incomplete if one or both cells contain an N. In cells B22:B24, using named ranges, create functions that count the number of students if their year in school matches the years listed in A22:A24. In cells C22C24, using named ranges, create functions that total the number of volunteer hours if their year in school matches the years listed in A22:A24. In cells C25:C26, using named ranges, create functions that total the number of volunteer hours if the criteria n A26:A27 is met Or Formula Auditing -F(ANDFG&G6PY","N") Guilford College Repair and Share Club 5 Studenti Network Cours LastName 30156 Boucher 58965 Garcia 56792 Glonden 48795 Blaise 23597 Linde 21486 Benoit 64537 Cyr FirstName Tom Franko Thomas Cheryl Alice Alexia Judy Programming Year Major Course Senior Computer Science Y Senior Computer Science Y Junior Sophomore Networking Senior Networking Senior MIS Junior Computer Science Y Sophomore Computer Science Y Junior Engineering Sophomore Engineering Junior MIS Courses Completed ANDY fogk test WNAME? UNAME? NAME? NAME? ENAME? NAME? NAME? NAME? #NAME? Volunteer Hour GPA Grad " "N") 1.21 treat ed 4.00 A 1 D. 58 3.67 B+ 110 391 A- 149 15 A 145 2.10 C 94 350 3+ 72 1.77 D 13 1.98 + 54634 Villani 46846 Zacheris 41123 Ching Mark John Home Insert Draw Page Layout Formulas Data Review View He fx 2 A @ @ @ @ Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More . Used - Time Reference Trig Functions Function Library Name Manager EOC Define VLOOKUP | | |