Possibly

=COUNTIF(A1:A20,"YES") & " Yes and " &COUNTIF(A1:A20,"No") & " No responses"

Mike

"nabanco" wrote:

Hello,

Is there a way to total all answers in one column. For example, looking to
count all the answers that were "Yes" and all the answers that were "No"

Thank you