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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
SUMIFS ONLY UNTIL the number REPEATS 1
SUMIFS UNTIL the number is repeating 0
Nested IF Function problem for Excel 2003 7
Ignore NA in a formula when I type it in a cell 4
Last "non-blank" value in a Row... 2
my first excel experience (share portfolio) 2
Help With Expanding A Formula 7

Top