I have a list of grades in excel. Which formula should I use to count how many "A" grades there are?
2006-11-16 07:48:09 · 4 answers · asked by sanja 2 in Computers & Internet ➔ Software
Using the Sum function will not work. You need to use the CountIf function. To do this, click in the cell that you want, then click on the = sign on the formula bar. Type CountIf and then hit Enter. Choose it in the bottom screen. Now, follow the wizard to get your results.
2006-11-16 09:36:35 · answer #1 · answered by Jame 3 · 0⤊ 0⤋
At the top of Excel click Data, then filter, it will help you filter out all the A grades, B's and whatever. It is always best to practice using MS software whenever possible to get a better understanding of it.
Good Luck
2006-11-16 18:46:05 · answer #2 · answered by ILuvDollz 2 · 0⤊ 0⤋
use the autosum button on the top of the page, it looks like a fancy pointy "E"
2006-11-16 15:59:33 · answer #3 · answered by Shadowfyre 6 · 1⤊ 0⤋
use the sum function.
if u need further help use the Help menu
2006-11-16 15:52:17 · answer #4 · answered by D *)sukky 3 · 0⤊ 1⤋