View Single Post
  #1   Report Post  
JerryS
 
Posts: n/a
Default Sumproduct with Date column

I have multiple columns where one contains a date formated as 6/6/2005 for
example. I have other columns with the rep id and product numbers. I want to
show how many of a product did a rep sell on a particular date. The problem
I'm having is getting the formula to work with the date. The data looks
something like this. Any sugegstions?

A B C
JS 253 6/6/2005
BO 134 6/3/2005
BO 253 6/6/2005


--
JerryS