IFERROR, how to implement

[ElPolloDiablo]

Hi,

I have a column of cells on the master sheet with the following formula

Please Login or Register  to view this content.

(next B13 and so on..) It shows value taken from multiple sheets. But if a sheet for the particular "row" doesn't yet exist it obviously shows #REF! How can I make those cells show 0 or no value at all?

IFERROR could be used for this if I've understood correctly, but I'm having trouble implementing it. Where should it be placed?

Thank you for any help

[Moo the Dog]

Try:

for a blank result: =IFERROR(SUM(INDIRECT(B12&"!$J$39")),"")
for a 0 result: =IFERROR(SUM(INDIRECT(B12&"!$J$39")),0)

- Moo

[ElPolloDiablo]

Thank you so much for your reply!

For some odd reason it doesn't work though, Excel finds a problem with the formula. And I just can't figure out what it is, everything seems to be the way it should :s