Powerutils 1.9 is now available for download containing 99 utils.
Countif and Sumif Functions
These functions are a live saver at times and once you know how to use them you will feel how you managed without them so long.
Countif : With this Function you can count the number of instances of a specific item in a large Range.
See the Table below
| First Name | Last Name | Basic |
| Rahul | Verma | 5000 |
| Rohan | Verma | 5500 |
| Mohit | Sharma | 5000 |
| Mohan | Verma | 5600 |
Suppose the above sheet had 2000 rows of data and you want to count the Number of LastName which are verma. Put a formula like this.
=countif(Search Range,criteria) where search range is the column Last Name starting from Verma to the last row of that column containing Verma and the criteria will be verma. The exact formula will be.
=countif(b2:b5,"Verma")
Sumif : This is similar to countif but this is used for Summing a range of data based on a specific criteria.
| First Name | Last Name | Basic | Salary |
| Rahul | Verma | 5000 | 25000 |
| Rohan | Verma | 5500 | 30000 |
| Mohit | Sharma | 5000 | 26000 |
| Mohan | Verma | 5600 | 34000 |
Suppose you had to sum the salary for all the employees whose basic was 5000, the formula would be
=sumif(c2:c5,5000,d2:d5)
Here c2:c5 is the range we are going to search for those employees whose basic is 5000, 5000 is the data we are going to search for you can put a cell range here which can contain 5000 and d2:d5 is the range whose amount you want added up based on the selection picked up by the other two parameters.
Please click here for a example.