How to SUM responses from cells with list data validation

Closed

Tara961 - Feb 28, 2017 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 28, 2017 at 12:05 PM

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

Data validation sum of cells
Display two columns in data validation list but return only one - Guide
Tmobile data check - Guide
How to reset safe folder password without losing data ✓ - Android Forum
Mint mobile data not working ✓ - Network Forum
Gta 5 data download for pc - Download - Action and adventure

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Feb 28, 2017 at 12:05 PM

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

Similar discussions

If a cell contains any text then add a value (with dates)

Macro to Create New Workbook and Copy Data at Each Change of X

Highlight cell if another cell contains any text

Formula for if cell contains word, assign value for multiple

format one cell based on a text value in another cell

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!