Oops, didn't see that you wanted on a monthly basis. Valko is right in using
a SUMPRODUCT then. My apologies.
--
Best Regards,

Luke M


"Luke M" wrote:

Try looking at COUNTIF and SUMIF in the help file.
--
Best Regards,

Luke M


"JPLong" wrote:

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