Countif Q
 

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

Countif Q
 

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


"John" wrote in message
...
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

Countif Q
 

Got this from a posting by Arvi Laanemets

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

"John" wrote in message
...
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