Sumif using cell reference in criteria

Posted by DB. Ross on July 08, 2001 3:39 AM

I am trying to write something like =SUMIF(D8:D25,>C5)
Where D8:D25 is an ordered list and C5 contains a threshold value for the list item to be included in the sum.

I find that IF functions and MATCH accept a cell reference as an argument but COUNTIF and SUMIF do not?

Posted by Tim Grollman on July 08, 2001 4:40 AM

I don't know if you've tried an array fomula (Ctrl-Shift-Enter). This one seems to work:

{=SUM(IF(D8:D25>C5,D8:D25))}

Tim

Posted by Aladin Akyurek on July 08, 2001 4:47 AM

Modify your formula as follows:

=SUMIF(D8:D25,">"&C5)

Aladin

=============