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

"AnnaV" wrote:


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