My AVERAGEIFS formula seems to consider only a single element out of the two that it should theoretically select. In the following case for instance, if I ask what is the average age of Beatles members who said yes, I only get 32, John's age in this case. I insist on having to "manually select" names (use a list).
My formula goes as following:
=AVERAGEIFS(C1:C9,A1:A9,"yes",B1:B9,{"john","paul","ringo","george"})
What am I missing?
Also is there such a thing as STDEVIFS? Because I would like to calculate the standard deviation of the data that meets the criteria in the above formula (once edited of course).
EDIT: Corrected the formula to include "YES" as a criteria:
The following should be entered with ctrl-shift-enter
=STDEV(IF((A1:A9="YES")*(B1:B9={"john","paul","ringo","george"}),C1:C9))