Hi everyone,
Im having this issue using COUNTIFS.. im tryinf to count the number of individuals on the P2 tab that are Young and Male that have a higher new GPA than old GPA (young and male individuals are those in the P2 tab that are 49 years or younger and male)
Im using this formula =COUNTIFS('P2'!E2:E101,"MALE", 'P2'!F2:F101, "<=49", 'P2'!N2:N101,"TRUE") but for some reason i keep getting zero as a result when it should be 15. Could someone help me figure out what im doing wrong?
Bookmarks