finding # of occurrences of information between two dates
I am trying to create a formula that will identify the number of sales for a
particular course on a monthly basis. This information will be fed to cells
on another sheet within the same workbook.
I know how to count the number of occurrences for a particular text stream,
but having that total based on the date is eluding me. I thought vlookup
might work, but I can't seem to get my head around how to make it calculate
correctly.
Any help would be GREATLY appreciated!
1/1/2007 Millwork Course - Complete Package
1/4/2007 Math For Enterprising Minds - Complete Package
2/24/2007 Millwork Course - Complete Package
3/1/2007 Principles of Proessional Selling - Complete Package
4/6/2007 Millwork Course - Complete Package
|