Apart from what you are doing to get the #VALUE! error, which others will
hopefully address, the other thing you have done wrong is to use the SUM
function but not told it what you want to add to F6+I6+L6+O6+R6+T6. You
haven't given it a second argument to the SUM function, so it isn't doing
anything useful for you. You may wish to look at Excel help for the SUM
function if you don't know what it is trying to do.

You may have intended either
=F6+I6+L6+O6+R6+T6
or
=SUM(F6,I6,L6,O6,R6,T6)

You will probably prefer the latter, as it ignores text entries such as the
" " string which you have requested from your IF function.
--
David Biddulph


"sandy" wrote in message
...
I am trying to add cells that have been filled with the VLOOKUP function.

=SUM(F6+I6+L6+O6+R6+T6)

Those cells have a value from a VLOOKUP function

=IF(ISNA(VLOOKUP(Q6,Points!$K$5:$L$28,2)),"
",VLOOKUP(Q6,Points!$K$5:$L$28,2))

If there is nothing in one of the cells I get the #VALUE! error (it works
if
there is a number there). What am I doing wrong?