Excel SUMIF Problem, cell ref as criterion

[Sprinkles]

I would appreciate any help with:

envision this:

A column of continuous numbers (I1:I57).

The total of the column is in I58 =sum(I1:157)

A cell (I60) also below that column with the result of some simpl
multiplication reference, let's say =D60*F60. The result is reveale
to be 1.08.

I would like to use 1.08 an upper limit. I would like to throw out al
numbers in that aforementioned column greater than (> 1.08)I60.
would like it automated, so I don't have to manually input the resul
displayed I60.

But the SUMIF command doesn't like the cell reference.

Sure, if I put in =I58-(sumif(I1:57,">1.08")), I get the correc
amount.

If I put in =I58-(sumif(I1:I57,">I60")), it just displays I58. N
subtraction occurs.

Is there a way to make it recognize the value in I60

 

[Peo Sjoblom]

Try

=I58-sumif(I1:I57,">"&I60)

 

[Sprinkles]

Thank you Peo.