Thread: count if or countifs how do I do it?
View Single Post
 
Old 06-11-2015, 09:35 AM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
  
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default
The formula works but I just realized that since this is to count grades and I need to count the grades that are >.70 but <than .79 to get how many students got a C grade, the formula you gave me counts >.70 and above. I tried playing around and used this

=(SUMPRODUCT((A5:A44="EE")*(G5:G44>0.77*(G5:G44<0. 79))))

but for some reason is counting all everything between 70 and 79 even though the A5:A44 or doing something else because is giving me a wrong counting
Reply With Quote