Question
8. On the COUNTIF sheet, in M2:M5, use the COUNTIF( ) function to calculate the number of students in each of the four grades (9th,
8. On the COUNTIF sheet, in M2:M5, use the COUNTIF( ) function to calculate the number of students in each of the four grades (9th, 10th, 11th, and 12th). The grade for each student is in column I. Then sum the number of students in M6. The value in M6 should be 97. NOTE: For this and the next five problems, do not use the entire column address inside the COUNTIF( ) function as in =COUNTIF(I:I,L2). Although it often works, it will cause problems if there is data further down the sheet.
9. On the COUNTIF sheet, use the COUNTIF( ) function to calculate the number of female and male students in M10:M11. The gender of each student is in column B. Then sum the number of students in M12. The value in M12 should be 97.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started