| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel count the number of scores within a range?
I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70. Any suggestions? I am sure it can be done... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel count the number of scores within a range?
You can use this method and adapt it to your grades
http://www.contextures.com/xlFunctions02.html#Range -- Regards, Peo Sjoblom (No private emails please) "Gatester" wrote in message ... I'm a teacher, and I'd like Excel to total how many students in each class get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70. Any suggestions? I am sure it can be done... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel count the number of scores within a range?
If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1: =IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F")))) and copy down. This will convert the grades to letters. Elsewhere enter: =COUNTIF(B:B,"A") =COUNTIF(B:B,"B") =COUNTIF(B:B,"C") =COUNTIF(B:B,"D") =COUNTIF(B:B,"F") to get the count of As,Ab,Cs,Ds, and Fs -- Gary''s Student "Gatester" wrote: I'm a teacher, and I'd like Excel to total how many students in each class get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70. Any suggestions? I am sure it can be done... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel count the number of scores within a range?
Gary's Student -
Thank you very much for taking the time to reply. It was exactly what I needed, and easily implemented. :-) Gatester "Gary''s Student" wrote: If you have a column of numeric grades (100,95,...) say in column A, then enter in B1: =IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F")))) and copy down. This will convert the grades to letters. Elsewhere enter: =COUNTIF(B:B,"A") =COUNTIF(B:B,"B") =COUNTIF(B:B,"C") =COUNTIF(B:B,"D") =COUNTIF(B:B,"F") to get the count of As,Ab,Cs,Ds, and Fs -- Gary''s Student "Gatester" wrote: I'm a teacher, and I'd like Excel to total how many students in each class get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70. Any suggestions? I am sure it can be done... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel count the number of scores within a range?
You are very welcome.
-- Gary's Student "Gatester" wrote: Gary's Student - Thank you very much for taking the time to reply. It was exactly what I needed, and easily implemented. :-) Gatester "Gary''s Student" wrote: If you have a column of numeric grades (100,95,...) say in column A, then enter in B1: =IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F")))) and copy down. This will convert the grades to letters. Elsewhere enter: =COUNTIF(B:B,"A") =COUNTIF(B:B,"B") =COUNTIF(B:B,"C") =COUNTIF(B:B,"D") =COUNTIF(B:B,"F") to get the count of As,Ab,Cs,Ds, and Fs -- Gary''s Student "Gatester" wrote: I'm a teacher, and I'd like Excel to total how many students in each class get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70. Any suggestions? I am sure it can be done... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Linear Mode
