Say you have this table...
A B 1 50 50 2 45 50 3 47 50 4 50 50
I want a formula that computes the sum of column A (SUM(A1:A4)) divided by the sum of column B (SUM(B1:B4)), without including the smallest value for A. For this example, the smallest value for A is 45, so I want a formula that would basically compute (50+47+50)/(50+50+50)
Thanks
Bookmarks