I have a dataset containing scores out of five that people have given three products, for a number of different flavours/attributes. I need a count of each score, per product, per attribute. This is easy enough doing each attribute separately, with a simple COUNTIFS: =COUNTIFS($B:$B,J$2,$C:$C,$I3)
However, to do this I need to know which column the scores are in (in this case, in column C). What I need in this scenario please is a formula that finds the column based on the heading (i.e. 'Sweet' or I2), so to search for the column that has the heading matching I2. Is is some sort of INDEX/,MATCH I need, or an HLOOKUP? Any help much appreciated!
Bookmarks