I have two columns of data. I want to calculate the mode of some cells in the
first column - including only those cells whose corresponding cell in the
second column has a value greater than 10.

For example:
2 | 20
1 | 11
2 | 8
1 | 16
2 |3
Would return MODE(2,1,1) = 1.

How do I pass the MODE() function only the criteria-filtered cells?

Thanks!