View Single Post
  #38 (permalink)  
Old 02-16-2008, 07:22 AM
AlpineMan AlpineMan is offline
Junior Member
 
Join Date: Oct 2007
Posts: 6
iTrader: (0)
AlpineMan is on a distinguished road
Default Sumproduct with Date as a field

I show a table below. I must count how much time 4 Jane occurs in jan..
If column A were simply Jan I include/understand how with do it but how I make-the with the dates in this help of the format... please...

A B
1/16/08 2 Jam
1/12/08 4 Jane
1/6/08 4 Jane
5/12/07 CCU
5/5/07 2 cohen
4/5/07 4 Jane
Reply With Quote