Try

=IF(SUM('Global KPI Monitoring chart'!D7:D8)=0,
IF(AND('Global KPI Monitoring chart'!D7="",
'Global KPI Monitoring chart'!D8=""),"",0),SUM('Global KPI Monitoring
chart'!D7:D8))

If this post helps click Yes
---------------
Jacob Skaria


"C Kreig" wrote:

Below is my current formula:
=IF(SUM('Global KPI Monitoring chart'!D7:D8)=0,NA(),SUM('Global KPI
Monitoring chart'!D7:D8))

What I need to do is if the cell blank I would like it not to show a value.
If there is a Zero in the cell I would like it to display the zero as the
value.

Thank you in advance for your assistance.