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:C 100=D3))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AnnaV" wrote in
message ...

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.


--
AnnaV
------------------------------------------------------------------------
AnnaV's Profile:
http://www.excelforum.com/member.php...fo&userid=9619
View this thread: http://www.excelforum.com/showthread...hreadid=496989