Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2017, 04:21 PM
Kflanigin Kflanigin is offline Summing non numerical cells Mac OS X Summing non numerical cells Office 2008 for Mac
Novice
Summing non numerical cells
 
Join Date: Jan 2017
Posts: 1
Kflanigin is on a distinguished road
Default Summing non numerical cells

I have a data sheet that has answers to a survey that are words rather than numbers. I'd like to be able to sum how many answers were given by respondent. Is there a formula that sums any type of entry in a cell or does sum only work with numbers. For example

respondent cell 1 cell 2 cell 3 cell 4
respondent 1 yes no yes


respondent 2 no yes

I'd like to be able to add a column to sum that respondent one gave 3 answers and respondents 2 gave 2 answers. Doesn't matter what the answers are. Just which questions they typed a response in.

Is that possible?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use a numerical merge field to subtract that number of months MichaelSpedding Mail Merge 8 11-11-2015 01:11 PM
Summing Non Contiguous Cells in a Row or Column Joe Ottenhof Excel 4 12-19-2012 04:13 AM
Plotting Numerical and Non-numerical Data Set Ife Excel 0 04-23-2012 10:35 AM
Summing non numerical cells Numerical ordering katejmchugh Excel 1 08-09-2011 12:57 AM
Summing non numerical cells SUMMING TWO COLUMNS LOGISTICS1 Excel 1 04-18-2006 06:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft