Counting rows that contain certain data across 3 collumns

I've tried to be very clear about what is being done and what has been tried, it's not a simple question so thankyou to anyone who is up for the challenge to help me tackle this problem!   I'm tryi...