software

I'm trying to Count the number of instances of quot;Yesquot; 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
Sorry my quot;Yesquot; and quot;Noquot; texts are in Column P, not Col Aquot;Johnquot; gt; wrote in message
...
gt; I'm trying to Count the number of instances of quot;Yesquot; in Column A (sheet2)
gt; BUT only if the values in Column A (sheet2) = to a value I have in C8 in
gt; Sheet1
gt;
gt; Column A and Column B on sheet2 are both of equal length.
gt; C8 = a date
gt; ColumnA = a range of different date
gt;
gt; Thanks
gt;
gt;
Got this from a posting by Arvi Laanemets

=SUMPRODUCT((P2:P165=quot;Yesquot;)*(A2:A165=Report!C8))

quot;Johnquot; gt; wrote in message
...
gt; I'm trying to Count the number of instances of quot;Yesquot; in Column A (sheet2)
gt; BUT only if the values in Column A (sheet2) = to a value I have in C8 in
gt; Sheet1
gt;
gt; Column A and Column B on sheet2 are both of equal length.
gt; C8 = a date
gt; ColumnA = a range of different date
gt;
gt; Thanks
gt;
gt;