COUNTIF formula for multiple Criteria

[AbrahamRunning]

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.

[jeffreybrown]

Check out this on Sumproduct http://xldynamic.com/source/xld.SUMPRODUCT.html

If you are using a version of Excel above 2003 look at Countifs

[AbrahamRunning]

I am actually running 2011 on Mac now. I haven't figured out how to edit my profile.

Thanks for the suggestions I will look into it and reply back.

[jeffreybrown]

To change it, go to User CP on the menu bar above and then on the left side of the screen scroll down and see the options. Probably a good idea to get that updated as it could make a difference and not only a difference, it seems not a lot of people have the Excel Mac (or I maybe I should say, not me).

Not 100% sure but I would go with the Countifs if you have it as it is much more efficient than Sumproduct.

[AbrahamRunning]

OK. Thanks again. I will give it a shot.

[AbrahamRunning]

So far the CountIfs formula is working for this purpose. Thank you very much, this will allow me to get rid of pivot tables and a layer of process.

[TerryE]

Hi my first time here but I have used this site for lots of help in the past. I normally use Excel 2007 and I have a spreadsheet for use by several other agencies who only have 2003. This means my countifs are not applicable. I have looked at sumproducts and understand the concept. What I need help with is a formula for the following:
Column A are date formats (to record meeting dates), Column B is a drop down list of outcomes (Yes, No, No reply). I need to record the number of times each month that yes, no and no reply where recorded. It is the greater than, less than part of the formula that I cannot get. i.e. how many times from 01/01/12 to 31/01/12 was "yes" recorded. Am I right in saying I cannot use sumproduct because I am asking for 2 conditions from the same array i.e. date? Thanks for any help.
Terry

[OnErrorGoto0]

No, you can do that with SUMPRODUCT. What is the COUNTIFS formula you are trying to replace? (also, a pivot table would be a lot simpler, I think).

[jeffreybrown]

Hi Terry & Welcome to the Forum,

Please follow the forum rules and start your own thread. This thread has been solved for the OP.