=SUMIF(D:D,H3) sum the values equal to H3
=SUMIF(D:D,"<" &H3) sum the values less than H3
=SUMIF(D:D,"" & H3) sum the values greater than H3

etc.

--
Gary''s Student - gsnu200839


"Joey" wrote:

How do I enter a sumif function to sum cells in column D in the range D3:D216
that match cell H3 criteria using absolute or relative cell references ?
Please Help.