I have a table with column A having a 0 or a 1, and column B having a value that I want to average. I know I can use averageif(A:A, "=1", B:B) to get the average of all of the values that have a 1 in column A, but I want something a bit more refined.
I want to be able to limit my average to the first ten 1's that show up in A.
Is this possible? I'd assume so, and that my problem is I just can't find the words to articulate what I need.
Best Answer
In a google spreadsheet, something like this should work:
or alternatively: