J Joey Mar 17, 2009 #1 How do I enter a sumif function to sum cells in column D in the range D3216 that match cell H3 criteria using absolute or relative cell references ? Please Help.
How do I enter a sumif function to sum cells in column D in the range D3216 that match cell H3 criteria using absolute or relative cell references ? Please Help.
G Gary''s Student Mar 17, 2009 #2 =SUMIF(D,H3) sum the values equal to H3 =SUMIF(D,"<" &H3) sum the values less than H3 =SUMIF(D,">" & H3) sum the values greater than H3 etc.
=SUMIF(D,H3) sum the values equal to H3 =SUMIF(D,"<" &H3) sum the values less than H3 =SUMIF(D,">" & H3) sum the values greater than H3 etc.
216