You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"PaladinWhite" wrote in message
...
That did exactly what I needed. Thanks a lot!

"T. Valko" wrote:

Try this array formula** :

=MODE(IF(B1:B510,A1:A5))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"PaladinWhite" wrote in message
...
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!