software

i m using this function =IF(SUM(F6:Q6)gt;0,SUM(F6:Q6),quot;quot;) but when i enter
number in h6 or it found blank range it is returning #ref!. I just want it
should return blank. How?
same function i m using in another sheet and it is working properly. why so
it is.

regards

RRS

There is nothing wrong with the formula. Try typing it again. What does a
simple =SUM(F6:Q6) return?
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email addressquot;Rao Ratan Singhquot; gt; wrote in message
...
gt;i m using this function =IF(SUM(F6:Q6)gt;0,SUM(F6:Q6),quot;quot;) but when i enter
gt; number in h6 or it found blank range it is returning #ref!. I just want it
gt; should return blank. How?
gt; same function i m using in another sheet and it is working properly. why
gt; so
gt; it is.
gt;
gt; regards
gt;
gt; RRS