Hi Mike:
Let us disect the modified formula:
'=IF(LEN(M9),IF($D$6:$J$14="TEXT",SUM($D$5:$J$13),""),"")
This is a nested IF formula -- the syntax being ...
=<font color=red>IF(condition,<font color=blue>{result_if-true}IF(condition,result_if_true,result_if_false),<font color=green>result_if_false)<font><font><font color=black>
"" says give me a blank (instead of a value, a zero, ... etc.
_________________
Regards!
Yogi Anand
This message was edited by Yogi Anand on 2002-12-20 21:50
This message was edited by Yogi Anand on 2002-12-20 22:35