Excel 2000

I have an INPUT_FORM tab and a REPORT 2007 tab in the same spreadsheet.

I have the following formula in REPORT 2007 to select out only the "YES"
values if there is a match to the month:

=SUMPRODUCT(--INPUT_FORM!$B$2:$B$1000,"AUGUST"),--(INPUT_FORM!$J2:$J$1000,"YES"))

I get a message saying there is something wrong with the formula, but can't
figure out what it is. I also tried with COUNTIF, and putting single quotes
around 'INPUT_FORM' - to no avail. Column J contains "YES", "NO", "Remind"

When I use
=MIN(COUNTIF(INPUT_FORM!$B$2:$B$1000,"AUGUST"),COU NTIF(INPUT_FORM!$J2:$J$1000,"YES"))
I get the total count of all Yes, no, remind which is 5, when the correct
answer is 4 YES cells.

Any ideas?

CaroleO