Ryan

Try using sum product in an if statement with this

SUMPRODUCT((($F$33:$F$151*0.85)<=$A$1)*(($F$33:$F$ 151*0.95)$A$1))0

There appears to problem with your sumif. The areas should be the same:

sumif($h:h,A$2,$f$33:$f$151)
either
(1) sumif($h:$h,A$2,$f:$f)
or
(2) sumif($h$33:$h$151,A$2,$f$33:$f$151)

therefore lets assume (2)

=if(SUMPRODUCT((($F$33:$F$151*0.85)<=
$A$1)*(($F$33:$F$151*0.95)$A$1))0,
sumif($h$33:$h$151,A$2,$f$33:$f$151),0)

I'm not sure about your last sumif....but I leave that for you to consider.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"RSS" wrote:

I need to know if anyone knows of an Excel function which can accomplish the
following task:

lookup a cell value within a given range (i.e., F33:F151) and if that value
meets

a certain criteria (i.e., = 85% and/or <=94%), then execute a sumif
function

(i.e., sumif($h:h,A$2,$f$33:$f$151)). If the value doesn't match the
criteria, have Excel

return a value of 0.

Thanks,

ryan