One way:

=SUMPRODUCT(--(A30:A1000=A7),--(D30:D1000="Yes"))

HTH,
Paul

--

"Connie Martin" wrote in message
...
Here's another one I've been mucking around with and can't get. In cell
C7 I
want a formula that will look at the date in A7 and then go to A30:A1000
find
those dates and then how many of them have the answer "Yes" in D30:D1000.
This one is a little more complicated. Thank you so much. Connie