Hi, guys,

I am using data tables in Excel 2010 for Windows.

I have this formula:

=SUBTOTAL(102,Table2[Key])

I want the subtotal to be conditioned on whether the key
value is greater than 16000000 (or more humanly readable,
16,000,000).

Thanks for the ideas.

/s