I have a very similar question to this recent post (how to summarize columns):
But my situation is a bit more complex and makes both suggested solutions not super practical (although they are great solutions!)
I have a bunch of tracking tables where I track daily info for everything for symptoms, weather, mood, foods, health measurements, etc. Altogether there are hundreds of columns. Each one is either a checkbox or a number.
Why not do multi-select lookups? Because I send each of these out to a google spreadsheet where I do correlation calculations. So I figure I have to keep them all separate (unless someone can suggest a simpler way).
So, there are too many to practically write out if statements for every column. And I can’t do multi-select lookups because I need to keep separate columns.