Hello, I'm new to numbers and although its pretty the same to Excel, I cannot figure out how to use the COUNTIF formula.
This is mainly what I have in the sheet:
A Student Number Name & Grade (which goes from 0-12)
I need to count how many people have passed the test with a grade greater than 3.
Thanks!
MacBook Air, OS X Mountain Lion (10.8.4)
the test conditions for COUNTIF and SUMIF and the related functions have to be in the form of a text string.
If the grade is in column C,
=COUNTIF(C,">3")
the test conditions for COUNTIF and SUMIF and the related functions have to be in the form of a text string.
If the grade is in column C,
=COUNTIF(C,">3")
Thanks! But what about if I only want a certain number of data and not the entire column?
Change the column reference ( C ) to a range reference ( C3:C17 ) to limit the count to those data in rows 3 through 17 of column C.
Here, Badunit's original formula ( =COUNTIF(C,">3") ) is in E2.
The revised formula ( =COUNTIF(C3:C17,">3") ) is in D2
The condition limits the count to the scores shown in the darker shade.
The range reference in the revised formula restricts the count to the students listed in the blue shaded region.
Regards,
Barry
Help with COUNTIF
