COUNTIF help
 

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.

COUNTIF help
 

plaw;192468 Wrote:
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.
That's more likely a SUMPRODUCT formula, for example:

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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=53043

COUNTIF help
 

plaw wrote:
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 he

http://www.contextures.com/xlFunctio...tml#SumProduct

COUNTIF help
 

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
--
Gary''s Student - gsnu200828


"plaw" wrote:

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.