Add Another Condition to Formula?

[danbl]

The existing formula (cell C25) works and provides the correct answer when the range C25:C42 contains "F" and "H".

I need to add a condition which says if the range of cells C25:C42 does not contain any "H", then enter the value in D14,otherwise continue with the formula as it is written. Is there a way to do this????

[Special-K]

=if(countif(c$25:c$42,"h")=0,d14,if($c25="",0,if($c25="h",d$15+d$20/countif($c$25:$c$42,"h"),if(c$25="f",d$14+d$19/countif($c$25:$c$42,"f"),0))))

[danbl]

AWSOME!!!!!!!

iT WORKS PERFECT IN MY TEST SHEET ............. GREATLY APPRECIATED.