I had good luck with my last problem that I thought I'd give it another shot. My assignment is to do a mock class that includes tha marks for assignment and exams and give them a letter grade. I was able to that with some help from here. Now I have to put those grades in a bar graph where it shows the number of students that have A's, B's and so on. My letter grades are in column "M" from M7-M26. There are grades ranging from A,B,C,D,F. When I did the graph it did it for individual students 1-20 what I need is for it to add the number of "A's" and "B's" etc. So there would be 5 bars for 20 students. Does anyone have a clue where I begin? Thanks for your time. Darren Platakis

Put this formula below the grades and create similar formulae for the other grades =COUNTIF(M7:M26,"=a")

Thank you, it worked like a charm. I was trying to do an "if" formula when I should have been doing "count if" Thanks again. Darren Platakis