How to SUM responses from cells with list data validation

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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