 |
|
|
|
|
|
|
|
|
|
|||
| In this case, we have a table with the names and
the score of each one of them, also a criteria table. We want to know, how many students were approved with 8,9 and 10 score. In order to solve this problem, we open the dialog box of our tool.
|
|||
|
|||
| Finally we press the Ok button. The result is showed below:
|
|||
|
|||
| We can realize that they are 5 people with score 8, there are 9
people with score 9 and 1 person with score 10. In this case we have counted those values equal to the small criteria table. Simple!! This tool, besides, allow us to make operations, such as Greater, Less, Equal or greater than, Equal or less than, searching of text, etc. Now, imagine all of the time and work that you would save if this table was 10 or |
Tools for Excel Tables
Secure Payment Options
| Pricing: |
|
Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site.
Microsoft � and Microsoft Excel �
are registered trademarks of Microsoft Corporation. OzGrid is in no way
associated with Microsoft.
Contact Us