ParExcellence
New Member
- Joined
- Nov 30, 2016
- Messages
- 2
Hi, everyone. I'm here because I have searched and searched for an answer to what I'm trying to do to no avail. I'll explain as best I can.
At work, I am trying to create a Summary sheet for some data we've been crunching, and my manager wants a table to display certain counts of certain data. The problem lies in how it should be counted.
Basically, there is a column with a record ID number in it, and for each code, I want to count how many instances of the word "yes"(it makes sense in context) appear in the row containing that record ID number. For an example, say there's three rows with ID numbers of A101, A102, and A103. In the Summary sheet, I want to put the count of how many times the word "yes" appears in the A102 row only in a cell in the Summary sheet.
I can't get it to work, and i wanted to hop on here and ask, is it possible to achieve that effect? Sorry if I'm unclear, I got rather rusty with Excel before I took this job. If I need to clarify, please just ask. And thank you all in advance for taking the time.
At work, I am trying to create a Summary sheet for some data we've been crunching, and my manager wants a table to display certain counts of certain data. The problem lies in how it should be counted.
Basically, there is a column with a record ID number in it, and for each code, I want to count how many instances of the word "yes"(it makes sense in context) appear in the row containing that record ID number. For an example, say there's three rows with ID numbers of A101, A102, and A103. In the Summary sheet, I want to put the count of how many times the word "yes" appears in the A102 row only in a cell in the Summary sheet.
I can't get it to work, and i wanted to hop on here and ask, is it possible to achieve that effect? Sorry if I'm unclear, I got rather rusty with Excel before I took this job. If I need to clarify, please just ask. And thank you all in advance for taking the time.