SumIf

  • Thread starter Thread starter Joe K
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top