Here is a formula that I am using which is working very well for what I need:

=SUMPRODUCT(--(MONTH('Fall 2008'!D2:D1000)=8),--('Fall
2008'!E2:E1000="Yes"),--('Fall 2008'!F2:F1000="New"))

This formula is in a worksheet tab called "Reports", and it's pulling data
from my "Fall 2008" tab.

Is there a way I can add something to this formula so that it also looks at
a listing of course titles in a column and does not count any that are
duplicated? For example, if I have an "Introduction to College Math" course
that is being taught by three instructors, each has a different course
number, but I want
to only count the "Introduction to College Math" course one time. Right
now, the way the formula is set up, it's counting every instance (section) of
the "Introduction to College Math" course. I would probably want to filter
this by the course name column.