Hi,
This is my first time posting so I know you'll be nice
I have created a sample spreadsheet (attached).
Please note the real data is far larger with thousands of reviews and multiple features that have groups as big as 8.
What I'm trying to do is to create formulas in the Summary tab where there are blank spaces.
I am fairly new to array formulas but used them in column B to calculate the average review scores for the groups.
I have countifs formulas for the single feature rows but don't know how to create a formula for each group row that will count the number of reviews that have at least one feature in that group where the review score is 3 or higher. I have all the grouped feature combinations in the Classes tab to the right. They don't include the negative options (00 or 0000). This helps me easily differentiate the review scores of those with at least one feature in a particular group and those which don't have any feature in that group (although this isn't included in the sample above)
I hope that all makes sense when you look at the data.
I know there will be a simple way to do it but it is beyond my Google Sheets level of brilliance!
Can someone please help me?
Thank you in advance
Emily
Bookmarks