How to SUM responses from cells with list data validation [Closed]

Report
-
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
-
Hello,

I want know if it is possible to total (SUM) the number of responses I have on cells which have the data validation.

I have set up a spreadsheet up on excel to input information received from a survey conducted. I have done data validation on the majority of the cells (drop down box/list) of responses such as Yes or No OR Confident, Somewhat Confident, Not Confident.

What I want to do is see how many Yes or No responses I received in total Or How many Confident response I received etc..

Any ideas would be most appreciated

Tara

1 reply

Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
466
Hi Tara,

Give the formula COUNTIF a try. It will let you input a range and a criteria and counts the number of times the criteria is found within the range.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!