Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
If one of the cells in the SUM range accidentally has a blank space
entered, you'll get that value. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I prevent the "division by zero" error in this formula | Excel Worksheet Functions | |||
Formula syntax error - chinese and gibberish | Excel Discussion (Misc queries) | |||
Formula error... | Excel Discussion (Misc queries) | |||
Formula Error | Excel Discussion (Misc queries) | |||
Formula MATCH error | Excel Worksheet Functions |