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.

 

[JBeaucaire]

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

That's more likely a SUMPRODUCT formula, for example

=SUMPRODUCT(--(A1:A100="cat"),--(B1:B100="red")

 

[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