Urgent!Formula to count how many people have answered yes to more than one question

Hi guys. Need some help urgently please!

I have a list of unique references(people) in column A and data in column B,C,D,E.F which are answers to questions.

I need a formula that calculates that total amount of references that have answered yes to more than one of the questions in column B,C,D,E and F.

Your help will be much appreciated

Thank you!!!

use a helper column (for example column G) with =COUNTIF(B1:F1,"yes"). Then use =COUNTIF(G:G,">0") to get the total.

You can use column G as a helper column, with this formula in G2:

=COUNTIF(B2:F2,"yes")

Copy this down to the bottom of your data. Then in H2, say, you can have this formula:

=COUNTIF(G:G,">1")

Hope this helps.

Pete

works great, thanks

works. thank you very much!