COUNTIF help

  • Thread starter Thread starter plaw
  • Start date Start date
P

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.
 
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
 
Back
Top