I have the following table:

John 8
Jean 7
Jane 100
Jean 9
Jeff 4
John 100
Jean 8
John 7
Jane 5

If I filter the above table on John, I will have

John 8
John 100
John 7

The function =SUBTOTAL(4,B2:B10) will give the value 100. However I would want the SUBTOTAL function to ignore the particular value 100, so that =SUBTOTAL(4,B2:B10) will give 8 in the above case.

How would I achieve this? Thanks in advance.