I looked at the information you sent, but it still doesnt help me with a date range. I may have overlooked it though. The example below is closest to the one that would help me, but my primary focus is to count the number of cells that have a date between 01/01/08 and 3/31/08. The SUM is not the main issue for my worksheet .

Example 2: To count the number of sales in 3 locations of service since a given time period.

Solution: In it's basic elements, this is a simple test. If the date to be tested against is in a cell it would be a simple
=SUMPRODUCT((C5:C309>$A$1))*(H5:H309="A"))
But this formula shows a technique to use embedded date strings that works, as far as I am aware, in all international versions of Excel.
=SUMPRODUCT((C5:C309>(--("2004/05/31")))*(H5:H309="A"))