Let's say I have the simple spreadsheet I've attached (I actually have a giant spreadsheet with 1000+ "Names", and about 12 "criteria," so is there a limit to the number of criteria you can search for?) I want to find the average Value for all Names that fulfill multiple criteria. (It would also be useful to know how many Names fulfill the specified set of criteria.)
For e.g. in one instance, I might want to find the average Value for all Names that are: Class M, Type SS, Original No. The next time I access the data, I might want to find the average Value for all Names that are: Class C, Type PP, Original Yes.
How would I do this? I'm also wondering if I should set up the sheet so that average Values for ALL possible combinations of the criteria are always visible, or whether I should have the User fill the criteria he wants to use each time he uses it. I would put a little shrugging emoji here, but don't know how!
For e.g. in one instance, I might want to find the average Value for all Names that are: Class M, Type SS, Original No. The next time I access the data, I might want to find the average Value for all Names that are: Class C, Type PP, Original Yes.
How would I do this? I'm also wondering if I should set up the sheet so that average Values for ALL possible combinations of the criteria are always visible, or whether I should have the User fill the criteria he wants to use each time he uses it. I would put a little shrugging emoji here, but don't know how!