Count if formula
 

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

Count if formula
 

=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.

"Neil H" wrote:

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

Count if formula
 

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


"Neil H" <Neil wrote in message
:

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

Count if formula
 

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

"bpeltzer" wrote:

=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.

"Neil H" wrote:

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