This should be a simple conditional function, but I can't figure it out... I'm creating a grade sheet and I would like excel to automatically calculate grade distribution as I'm inputing the grades. For instance, let's assume I have a list of 20 grades in the D column for the first assignment. As I input those grades, I want excel to tell me how many of them are in the A-range, B-range, etc. I want this done for each assignment, so I would need a corresponding calculation for the E column (2nd assignment). Can anyone help me out?