Try this:

=Sumproduct((N1 :N100Today())*(BM1:Bm100="Yes"))

Adjust your ranges as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JHolmes" wrote in message
...
Is there any way for a formula to check more than one criteria before
counting? So if I have dates in Column N - I have the formula to check
that
date is past today's date, then in column BM I have a Yes or No value, and
for the formula to only count the row when it contains a "Yes" in BM? I
have
tried using nested countif and doesnt seem to work.