Countif Q

[John]

I'm trying to Count the number of instances of "Yes" in Column A (sheet2)
BUT only if the values in Column A (sheet2) = to a value I have in C8 in
Sheet1

Column A and Column B on sheet2 are both of equal length.
C8 = a date
ColumnA = a range of different date

Thanks

 

[John]

Sorry my "Yes" and "No" texts are in Column P, not Col A

 

[John]

Got this from a posting by Arvi Laanemets

=SUMPRODUCT((P2165="Yes")*(A2:A165=Report!C8))