Formula error
 

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in £) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated

If one of the cells in the SUM range accidentally has a blank space
entered, you'll get that value.

anyway then to count a blank space as zero??

"Dave O" wrote:

If one of the cells in the SUM range accidentally has a blank space
entered, you'll get that value.

Maybe

=IF(ISBLANK(K4),"",SUM(R4,R6,R8,R11,R14,P17))

Anthony wrote:

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in £) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated

--

Dave Peterson

thanks Dave P - that did the trick - easy when you know how !

"Dave Peterson" wrote:

Maybe

=IF(ISBLANK(K4),"",SUM(R4,R6,R8,R11,R14,P17))

Anthony wrote:

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in £) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated

--

Dave Peterson

And I bet that at least one of those cells wasn't really blank.

(It may have contained text (even a single space character).)

=sum() ignores cells with text.
But =a1+b1+c1 will cause errors if there's text in one of those cells.

(=sum() doesn't need those +'s either.)

Anthony wrote:

thanks Dave P - that did the trick - easy when you know how !

"Dave Peterson" wrote:

Maybe

=IF(ISBLANK(K4),"",SUM(R4,R6,R8,R11,R14,P17))

Anthony wrote:

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in £) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated

--

Dave Peterson


--

Dave Peterson