Hi

3 choices:

1: Wrap the formula inside an IF function:

=IF(formula=0,"",formula)

That will make the formula twice as long.

2: Goto ToolsOptionsView

Uncheck: Zero values

3: Use conditional formatting

Select the cell
Goto FormatConditional Formatting
Cell value is equal to 0
Set the font color to be the same as the fill color.

Biff

"Steved" wrote in message
...
Hello from Steved

If the cell has an 0 as a value what is required please to make it blank.

=SUMPRODUCT(('Planned Kilometres'!$A$4:$A$109=1)*('Planned
Kilometres'!$B$4:$B$109="P")*'Planned Kilometres'!$AC$4:$AF$109).

Thankyou.