I have a worksheet that has 4 columns like this:

Column Q = date
Column U = yes/no
Column V = yes/no
Column S = date

What I need to do is count the number of cells that have EITHER a date value in Column Q, AND "yes" in both Column U and V, OR a date value in Column S.

I'm coming up with this, but it doesn't work:

=SUMPRODUCT((Q2:Q101>=TODAY()-365)*(U2:U101="YES")*(V2:V101="YES")+(S2:S101<TODAY()-365))

The value returned is 89, but manually counting the cells comes up with 55.

Any help will be greatly appreciated!!