SumIf

J

Joe K

I am attempting to use the Sumif function, but would like
the value in a given cell to be used as the criteria. I
can not get this to work; however, if I hard-code "<10"
in the formula it works. I would like reference a given
cell that contains the value 10.

Thanks
Joe
 
N

Norman Harker

Hi Joe!

Here's an example of summing amounts in B1:B10 based upon a criteria
in A1:A10
=SUMIF(A1:A10,"<"&G1,B1:B10)



If you merely want to sum A1:A10 based on that criteria use:



=SUMIF(A1:A10,">"&G1)



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top