View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

=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