In the workbook attached, how do I calculate the number of boys and the number of girls whose total marks in column N is >=200 and <=249?
My formulas in cells C50 and D50 are not working.
FORUMS.xlsx
In the workbook attached, how do I calculate the number of boys and the number of girls whose total marks in column N is >=200 and <=249?
My formulas in cells C50 and D50 are not working.
FORUMS.xlsx
Last edited by gko_87; 11-23-2017 at 05:26 AM.
OnditiGK
You can use a countifs formula like this
Formula:Please Login or Register to view this content.
Just change "M" to "F" for girls
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Try
=COUNTIFS($C$9:$C$44,"M",$N$9:$N$44,">=200",$N$9:$N$44,"<=249")
=COUNTIFS($C$9:$C$44,"F",$N$9:$N$44,">=200",$N$9:$N$44,"<=249")
or can use
for Male
Formula:Please Login or Register to view this content.
for female
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you John, Spitfireblue and shukla. Your help came at the right time. The primary schools national exams were released yesterday and some headteachers came to my office, wanting me to analyse the results for them.
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks