formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
There is nothing wrong with the formula. Try typing it again. What does a
simple =SUM(F6:Q6) return?
best wishes
 
Back
Top