Thread
:
Sumproduct with Date column
View Single Post
#
3
Don Guillett
Posts: n/a
just put a date formatted the same into a cell somewhere (a1)
=sumproduct((c2:c2000=a1)*1)
to count the sales on that date
--
Don Guillett
SalesAid Software
"JerryS" wrote in message
...
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
Reply With Quote