Hi,
Quote:
|
I want to use the second variable in the SUMIF formula to refer to the contents of a cell rather thyan a string.
|
Suppose your condition is ">100", so if it was in the formula it would look like this:
Code:
=SUMIF(C15:C45,">100",F15:F45)
You could then put 100 in T10 and reference it like this:
Code:
=SUMIF(C15:C45,">"&T10,F15:F45)
In my experience, that's what most people do.
If you want the > operator in cell T10 too, then you would put this in T10:
And then your formula would be
Code:
=SUMIF(C15:C45,T10,F15:F45)
If you want to see more examples, here's a
tutorial I wrote on SUMIF.