|This formula will count the number of cells that contain data in A1:A45 and compare it the number of "Yes" entries in B1:B45.|
If the numbers match, it will produce Yes. If not, No.
=IF(COUNTA(A1:A45) = COUNTIF(B1:B45,"Yes"),"Yes","No")
Obviously, this formula will need to be modified to fit your exact situation. I'm just showing you the concept.
Let us know if that works for you.