S
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
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