Hi,

Create a Pivot table. Drag column D to the row area, column M to the column
area and column M (again) to the data area.

Thank you.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Destrachan" wrote in message
...
My brain's on overload at the moment, so I'm turning to you guys for
help. I need help w/ a formula that will count the number of sales
that someone had based on a certain date...I thought I could use
sumproduct, but I'm beginning to wonder if I was wrong about that.
The relavant columns are D & M.

Col D Col M
12/24/2009 Andy
12/24/2009 Charles
12/24/2009 Andy
12/25/2009 Charles