Get instant live expert help on count if yes

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a spreadsheet with answers to a survey. I need to be able to count a row if any of the questions were answered "yes", but to only count each row once for a yes and not once for each yes. Advice?
Solved by G. J. in 23 mins
If value in Network Name column on 'Email" Sheet matches value in Network Name on "Post Count" Sheet THEN -Input Yes on Email Sheet -- 'Found on Post Count' Column. -- Yes on every row that matches -- Input value of post count, 1 month engagement score and users count FROM Post Count Sheet to Email Sheet value needs to repeat on every row with same name
Solved by M. J. in 27 mins
=IF(O3:O347>0,IF(F3>G4,"YES","NO"),"NO") I want to express this as a percentage but want to ignore the original No count
Solved by X. H. in 30 mins
I have a 3 column table showing a list of article titles, article subheadings and a yes/no column. An article is complete if all subheadings have a corresponding 'yes'. There are mulitple subheadings per article title. If there a formula to count the number of article titles with all corresponding subheadings marked as 'yes'?
Solved by K. W. in 30 mins
Hi, Im looking for a formulae where i want to count mutliple text in one cloumn. Example in a coloumn I Have Yes, No, NA and i want the count of Yes and NA
Solved by X. D. in 13 mins