I have rows of records that are composed of customer information

I want to create a reporting file that will allow me to pull a report and it will count the number of records matching certain criteria

lets say they have a client ID, I want it to count unique client ids even if the person is in the raw data multiple times
lets say they have a term and a status, I want unique ID in term "Fall Quarter" and Status "ready to buy"

Is this possible with count if? is there something else I should be looking at?

Right now I spend a lot of time, making pivot tables and transferring data to a report from these pivot tables.