I have a 2 sheet workboook. Sheet tab 1 (External Comm) contains all of the records, currently about 500 and growing. Sheet 2 (CalcSheet) is a compilation of the results in numbers (sum), based on selected results. Compiling all of the results is easy for the whole list:

=COUNTIF('External Comm'!E7:E1000,"Tour") There are currently 134 records defined as "Tour"

Now I am trying to select the same type of results, but based on a date range (column A of sheet tab 1). Here is my current formula but it returns a negative number of -314. The correct number should be 23 Tours for the dates I indicated.

=SUMPRODUCT(-('External Comm'!A7:A1000>=DATEVALUE("4/1/2010")*('External Comm'!A7:A1000<=DATEVALUE("3/31/2011")*('External Comm'!F7:F1000="Tour"))))

One other item, the current range of records are from row 7 to row 407. However, I used a Macro to insert a new row in row 7, moving all current records down a row. I use the range of "1000" to allow for future growth, so I am wondering if the blank rows from 408 to 1000 is causing the problem???

Thanks for any assistance and help.