IF and lookup functions combined?
 

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

IF and lookup functions combined?
 

i may be confused yet lets see if it is this way...

$h:h list of %...

=sumif($h:h,"<94%",$f$33:$f$151)-sumif($h:h,"<85%",$f$33:$f$151)


--
*****
birds of the same feather flock together..



"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