Formula or fuction to work out total number of males females that have a specific score.

Hello,

I'm nearly done with my spreadsheet, there is one formula I just cannot think of how to do. I have created a spreadsheet that works out the reading age and actual age of a child. I've then created a formula that works out the difference in age.

I've then created a summary table that shows how many children fall between 2 parameters. E.g. How many scored over 2 years compared to their actual age, how many scored between 1 and 2 years+, age and 1 year+ etc.

I've managed to wirte a formula that totals how many children have scored in these particular parameters (See L13 to U13).

I now need a formula that will look at the data in (I11:I40) and count how many males and females have scored. E.g. M11 should have the value 1. N11 should have the value 7. N12 should have the value 6.

Is this possible? I have created a male / female column in column A.

Thank you for any help

You could try the countifs function

In M11 and copy down
=COUNTIFS($A$11:$A$40,K11,$I$11:$I$40,">1")

In N11 and copy down
=COUNTIFS($A$11:$A$40,K11,$I$11:$I$40,">0")

Windy

Originally Posted by windy58

You could try the countifs function

In M11 and copy down
=COUNTIFS($A$11:$A$40,K11,$I$11:$I$40,">1")

In N11 and copy down
=COUNTIFS($A$11:$A$40,K11,$I$11:$I$40,">0")

Windy

Thank you very much Windy! I'm only starting to getting the possibilities of excel.

Thank you so much for your copy of the spreadsheet! You really saved me some time figuring it out slowly.