I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.