I need to count how many times in a list that a name comes up with a certain
date.
I need to count how many times in a list that a name comes up with a certain
date.
=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
=SUMPRODUCY(--(A1:A100="the_name"),--(b1:b100=--"2004/01/15"))
--
HTH
Bob Phillips
"marblelife" <[email protected]> wrote in message
news:[email protected]...
> I need to count how many times in a list that a name comes up with a
certain
> date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks