Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
COUNT Formula?? | Excel Discussion (Misc queries) | |||
Need a Count Formula | Excel Worksheet Functions | |||
need help with count formula.. | Excel Worksheet Functions | |||
Count If formula | Excel Discussion (Misc queries) |