Where are you checking for the course number now? This formula is
looking for month=8 in column D, column E="Yes" and column F = "New".
What do the columns E and F represent? Presumably you have a field
where the course title is recorded?

Please give further details of the layout of your data.

Pete

On Apr 27, 3:26 pm, Chris Hofer
wrote:
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.