I don't think that =IF(V30.11,"") will give you the desired result !
There's probably a better solution but I always use something like:
=SUMIF(V3,"0",V3)


"Eduardo" wrote:

Hi,
The problem with your formula was a "," instead of "." after the 0, try

=IF(V30.11,"")

if this helps please click yes, thanks

"litm" wrote:

I have added an if statement under X5 so that if another cell had avalue then
it wold show here. I have then written anoher if statement under X5 points
=IF(V30,11,""). This should not return 11 in this example as X5 does not
have a value, the cell just has =IF(E30,E3,"")

How do I get the X5points to return nil.
X5 X9 X12 VT7 Other X5 Points X9 points X12
2200 11 17 17 12

--
Matty