I have numerous linked spreadsheets. the master spreadsheet is a summary of eight other spreadsheets. So for example, cell A3 on the master might be cell A3 on spreadsheet 1, plus cell A3 on spreadsheet 2, plus cell A3 on spreadsheet 3 and so on. The problem is, if cell A3 on all the 8 spreadsheets is blank (because it concerns data to be entered in December), the master spreadsheet cell A3 value is given as "0". This messes up the linked graph, as it returns a figure of 0 for December, when in fact we haven't got to December. Is there a formula that could be used, e.g. "if the cell A3 in spreadsheet 1 and cell a3 in spreadsheet 2... is empty, then master cell a3 = empty, otherwise master cell a3 = (cell a3 in spreadsheet 1, plus cell a3 in spreadsheet 2 etc.) Or is there an easier way?

On the same lines, when I link a cell directly to a cell in another spreadsheet, and the source cell is empty, again it returns a value of "0" in the linked cell, rather than leaving it blank. Is there a way to link the two so that the linked cell on the graph is null if the source is null?

Thanks for your help,

Pete

On the same lines, when I link a cell directly to a cell in another spreadsheet, and the source cell is empty, again it returns a value of "0" in the linked cell, rather than leaving it blank. Is there a way to link the two so that the linked cell on the graph is null if the source is null?

Thanks for your help,

Pete

## Comment