R
RSS
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
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