formula problem

R

Rao Ratan Singh

i m using this function =IF(SUM(F6:Q6)>0,SUM(F6:Q6),"") 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
 
B

Bernard Liengme

There is nothing wrong with the formula. Try typing it again. What does a
simple =SUM(F6:Q6) return?
best wishes
 
Top