OverlordQ

Those bandages look like what's used to cover tattoos, so was curious if that's what they were.

I have three sheets. ScoreInputs, RawScores and ScoreMatrix.

ScoreInputs is basically a single column of raw input scores.

In ScoreMatrix, the first row is a list of score categories, then going down, a non-empty value if that question applies to that category.

In RawScoreCalc I'm trying to do the proper summation of the values from ScoreInputs based on ScoreMatrix.

I've started with

=MATCH(INDIRECT(ADDRESS(ROW() - 1, COLUMN() ) ), ScoreMatrix!$B1:$Z1) 

which will tell me which is the proper column to query from ScoreMatrix, and then

=COUNTIF(INDIRECT

It sits in a little pouch under your brain.