The result will have to show something, a blank or a 0but if you perform calculations on these columns a blank cell might cause issues.

What you can do is add a Conditional format to the column or columns that if the value is 0 to make the font color white, that way it is there but you won't see it.

Another way is the Custom Number format, you format it only por ppositive and negative numbers and nothing for zero's

0;0;

0.0;0.0;

;;; will show an empty cell 

Hope my explanation makes sense

Can you clarify the "when I graph all the data" comment? Charts will only generally ignore blank cells (no cell that contains a formula is truly blank) but for some chart types there can be workarounds, such as returning #N/A instead.

NO NEED TO ADVISE - LEFT HERE AS A MATTER OF INTEREST - ISSUE RESOLVED (Just made the default in their SharePoint List default as 0 for the relevant columns)

Hi Gents,

The when I graph is probably a red herring; what I'm really looking at is getting a return of nothing if there is no number. 

There are two formulas at play here

The first looks at a specific row on an owssvr; this looks at a specific week and extracts two pieces of data (these being)

1. A Unit, and

2 the number of people in that unit (TTS 5, CRTS 103 etc.)

{=SUM(IF(ISNUMBER(FIND($A6,C$9:C$250)),VALUE(RIGHT(C$9:C$250,FIND($A6,C$9:C$250)+1)),0))}

The fomula above then looks for the unit (A6) in the column (C9: C250) if it finds it, then it retrns the number of pers in that unit for that week   VALUE(RIGHT(C$9:C$250,FIND($A6,C$9:C$250)+1)),0))}

The issue is if; the wek period has not yet arrived, or if someone hasn't completed the data for the owssvr thenn there is no number to return so I get a #Value error.

I can live with it; but was just wondering if there was a way to get it to return blank if no number exists

Cheers and as always

TIA

Just to point out, you can use the ISERROR function and set it to return whatever you want