This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
1
Formula to Count Answers in Multiple Columns
Post Flair (click to view more posts with a particular flair)
Post Body
Hello, I'm sure this is quite basic, but I've been working in a huge spreadsheet of survey responses and my brain is fried.
I have 5 columns of responses to a question on race. There was no option for multiple races so there are quite a few respondents that picked 2 or more options. How can I count those in a new column? And how can I remove those responses from the count of a single race? Happy to provide more context if needed.
And thanks in advance for helping.
Author
Account Strength
80%
Account Age
7 years
Verified Email
Yes
Verified Flair
No
Total Karma
190
Link Karma
60
Comment Karma
130
Profile updated: 5 days ago
Posts updated: 1 month ago
Subreddit
Post Details
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 4 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...