I m working on a database in which i need to Count the employees whose salary is based on Different ranges.I tried The Formula COUNTIF but i m not getting the accurate results.i dont know where i went wrong.I even Tried using the sumproduct or Sum (Array Formulas).
I also need to Show the same in a pivot Table.For example all the employees ranging from 0 - 5000 ,5001 - 10000 and so on.
How do i achieve this. Please tell me how to build pivot table & Pivot Chart as well as the regular countif formula.
Thanks in advance.
Bookmarks