I have a spreadsheet where I am amassing metadata and statistics based on filters. For each row of my summary spreadsheet, I want the full statistics of all of the data in my spreadsheet that is relevant to that filter.
Datatype |Filter |Mean |Median...
All |None |15 |12
When C < 15 |(C2:C1000<15) |12 |10
In order to save time, I'd like to be able to write my formulae for my statistics based on a condition I have pre-written in the "filter" column rather than have to paste it into each filter. Example of what I'm trying to do:
where A2:A1337 is my data, I2:I1337 < C2:C1337 is another condition, and A1 contains the plaintext condition of the filter I'd like to apply to this filter statement (so like the cell in the 3rd row, 2nd column in above example).
I believe I could also do what I want with queries or using tons of space by using multiple stages of filters and running stats on those new tables, but I'd really like to save myself space and trouble. Am I overlooking an easy way to "insert" plaintext as conditions into filter commands?