Thread
:
Count if formula
View Single Post
#
3
Posted to microsoft.public.excel.misc
JMay
external usenet poster
Posts: 422
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
Reply With Quote
JMay
View Public Profile
Find all posts by JMay