Sure...not a problem...

To answer your first question, I am not actually checking the course number
at all in any formulas I have set up.

In column E, I have a drop-down list set up where the heading is called
"Blended". If the couse fits this criteria, we select "Yes" from the
drop-down. If not, we select "No".

In column F, I have a drop-down list set up where the heading is called "New
OR Revised". If the course is brand new or revised, we select the
appropriate choice ("New" or "Revised") from the drop-down list.

The course number resides in column B. Generally, this is a nine-digit
number which varies from course to course. In the "College Math" course
example, the number is 804-106-### where ### is a three digit course section
number. I have this column set up where I can enter in a string of 9 digits
(ex: 123456789) and it will automatically add the dashes for me (ex:
123-456-789) upon hitting Enter.

Column C contains the course title. Again, in the example, the course title
would be "Introduction to College Math", but I only want to count that title
one time in my formula even though we have three unique course section
numbers for it (example: 804-106-001, -002, -003)

Chris

"Pete_UK" wrote:

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.