Arrayformula to count instances of specific text in a row
Long story short, I used copyDown to copy formulas into new Google Form submissions in my Sheet. I have a Sheet with multiple tabs and multiple forms inputting data and using copyDown. The addon was only intended to work with one tab; and it finally stopped working on me. I have been updating the formulas info arrayformulas that achieve the same thing as copyDown.
One arrayformula I'm trying to figure out is one that checks a row, let's say A2:M2, for all instances of the text "Almost Always" and returns the number of occurrences. Previously, using the addon, it was just a simple COUNTIF formula. I haven't been able to get that into an arrayformula that works on multiple rows/as new submissions come in.
Is this possible?
Posted Sep 30, 2017, 3:45 PM UTC
Could you post your sheet or a sample copy of it?
COUNTIF should work the same..
Thank you for the quick response. Sure. I'm chasing the kid around and will post it when I get back in.
Here is a link to a sample: https://goo.gl/RXbjoR
Countif seems to count for all the values of every row and return it to the cell H2. I'm hoping to have it spit a count for each row.