COUNTIF help

[plaw]

I need a countif formula that will function with two requirements in two
separate columns. So essentially it only counts if it matches the two
requirements.

 

[Glenn]

I need a countif formula that will function with two requirements in two
separate columns. So essentially it only counts if it matches the two
requirements.

Look here:

http://www.contextures.com/xlFunctions04.html#SumProduct

 

[Gary''s Student]

You need to use countif's big brother, SUMPRODUCT:

If A1 thru B6 contain:

dog big
dog small
cat small
cat small
cat small
dog big


Then
=SUMPRODUCT((A1:A10="dog")*(B1:B10="big"))
will display 2.

The number of records with dog & big