I was using the formula below:

=SUMPRODUCT(--(N1:N100<TODAY()),--(BM1:BM100="yes"))

and it doesnt actually only return the number of rows which have both a date
in the past in col N AND have a value of "yes" in col BM.
it is then returning the total amount of times "Yes" is in BM - not just the
amount of times that it occurs in a row where the date (col N) is before
today's date. Any idea how i can restrict it to just where the date is in the
past AND col BM ="Yes"?
thankx again...