To count each cell you can click the Fx function. This will bring up a couple of different options you can choose from. In the most recently selected dialog box you want to choose the count option. After clicking that it would show the beginning of the equation after the = which is right next to the Fx function sign. It should look like this inside the text box (=Count(A1:A20)----this indicates the cells you want to count. Or you could simply choose the entire column by inputing (A:A). To add up the numeric numbers you simply go to the same area and instead of choosing count, choose the sum. The formula should look like this (=Sum(A12:A25)). Note the outside parenthisis should not be there in your formula. If you don't feel like going to the Fx function you can simply input the formula in yourself. Then there is a Countif or a Sumif. The two basically do the same thing, the IF tells the formula to only count the cells with the specified information inside them. ie. (Countif(A:A, "student")), or (Sumif(A:A, ">3900")). IF you have three cells with;5000, 200, 4000. The sum would be 9000. I hope this information helps you out.
----- Sneilan wrote: -----
i want to highlight a list of cells (with people's names) and have it count how many cells i selected. is there a way to do this?
also, how do i do this with numeric cells and have it give me the total?
thanks for the help!
