Count if 3 different conditions exist

A

AnnaV

I have 3 columns of information. Column A has a date (01-Jan-05), column
B has a name, column C has either F, Inf, or Inv. I want a formula that
will count any date in column A that is January, and column B is Adam,
and column C is F.
 
R

Ragdyer

Put the number of the month you're looking for in D1 (Jan=1, Feb=2,
etc....),
Name in D2,
And ID's in D3,

Then try this:

=SUMPRODUCT((MONTH(A1:A100)=D1)*(B1:B100=D2)*(C1:C100=D3))
 
B

Bob Phillips

=SUMPRODUCT(--(MONTH(A2:A200=1),--(B2:B200="Adam"),--(C2:C200="F"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
E

Elkar

Try this:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(B1:B100="Adam"),--(C1:C100="F"))

And of course, change the cell ranges to match your needs.

HTH,
Elkar
 
Top