How do I write a conditional statement in Excel to count if two c.

[marblelife]

I need to count how many times in a list that a name comes up with a certain
date.

[Dave Peterson]

=sumproduct(--(a1:a10="marblelife"),--(b1:b10=date(2005,1,16))

is one way

marblelife wrote:
>
> I need to count how many times in a list that a name comes up with a certain
> date.

--

Dave Peterson

[Bob Phillips]

=SUMPRODUCY(--(A1:A100="the_name"),--(b1:b100=--"2004/01/15"))

--
HTH

Bob Phillips

"marblelife" <marblelife@discussions.microsoft.com> wrote in message
news:284ACFA4-BFB1-4219-A3A5-68BAB3FC7D2C@microsoft.com...
> I need to count how many times in a list that a name comes up with a
certain
> date.