Excel: COUNTIF and more.

In the picture above you can see another Excel lesson. If you wish to do what I've done, you have to follow the following footsteps:
For the MINIMUM you have to use the =minim(C2:C11) Using the ":" will be a lot shorter then adding from C2 to C11 all the numbers. After typing the following formula, press ENTER and you get your result for your first calculation.
The next steps in the picture above is for the MAXIMUM. The formula is the same, but instead of MINI, you type MAX. It will look like =MAX(C2:C11)
The next steps is what this article is mostly about...about the COUNTIF.
The formula is like this. =COUNTIF(C2:C11, "< 30") (( I added the number 30 as a example but you can add what number you like))
That's how the result should like...in the picture above, the COUNTIF is the third one.
The next it's about percentage, for that you must enter the "Format Cells" by right clicking on the cell you want to add this particular percentage. After entering the "Format Cells" select the option "Percentage" and add 0, then you will be able to calculate the percentage. To calculate it, you must use the following formula. =F3/F10. You can see what I've selected by looking at the picture above.
Well, hope this article helped you.