CountIF in Excel
Count IF in Excel
Another useful function that uses Conditional Logic is CountIF. This one is fairly straightforward. As its name suggests, it counts things! But it counts things IF a condition is met. For example, keep a count of how many students have an A Grade.
To get you started with this function, we'll use our Student Grade spreadsheet and count how many students have a score of 70 or above. First, add the following label to your spreadsheet:
View Docs
Posted by paiya
on 05:34.
Filed under
Spreadsheet Tutorials
.
You can follow any responses to this entry through the RSS 2.0