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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 28, 2017 at 12:05 PM
Related:
- Data validation sum of cells
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Sum if greater than and less than cell value ✓ - Excel Forum
- Amd data change update new data to dmi ✓ - Windows 10 Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 28, 2017 at 12:05 PM
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
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