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