Count if formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of students with their GPA in a column. At the bottom of the
List I want the teachers to be able to type in cells what range is an A,
(example: B14 = 4.0 in C14 = 3.5) These two cell would represent a range for
an A. I want a formula that will look in these two cells for a range then go
to the list and count how many students fall with in this range. In other
words how many A's do we have. Thanks
 
=COUNTIF(A:A,">="&c14)-COUNTIF(A:A,">"&b14) will count how many values in
column A are >= the value in C14 and <= the value in B14.
 
With the Numeric Grades in Column A
Enter In:

G2
=COUNTIF(A:A,">"&$C14)
G3
=COUNTIF(A:A,">"&D$14)-SUM(G$2:G2)
G4
=COUNTIF(A:A,">"&E$14)-SUM(G$2:G3)

HTH
 
This Worked out great. I had to chang the c and b around, because I put my
higher GPA in b. Thanks.
 
Back
Top