Google Spreadsheet Post #1176
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 07, 2013
user notarealpanda (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/_xMvS3f8HTI)
Count multiple entries in a single cell
I used 'countif' to count how many times certain words were submitted but it never occurred to me that one person could submit multiple words. Is there any way to count a cell if it contains a word and not just if it's the only word in the cell?
For example, let's say someone submitted "Lorem," "Ipsum," and "Dolor." I want the the three cells that count those words to count that one cell because it contains the word.
---
Here's a sample spreadsheet
---
Entries are made on the first sheet and calculated on the second. As you can see, the entries are only counted if there is a single item in the cell. I need to either find a way to count multiple items in a cell or a different way to record the entries.
----------------------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment