I'm trying to count 3 gr students scoring between 64 and 69. I'm looking at all students grs. 3-5. I'm using this but its not working.
![]()
=COUNTIF(And(D2:D370,3,COUNTIFS(E2:E370,">64",E2:E370,"<69")))
I'm trying to count 3 gr students scoring between 64 and 69. I'm looking at all students grs. 3-5. I'm using this but its not working.
![]()
=COUNTIF(And(D2:D370,3,COUNTIFS(E2:E370,">64",E2:E370,"<69")))
Last edited by Wskip49; 03-22-2011 at 09:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks