Hi,
I have a column of cells on the master sheet with the following formula(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?Formula:=SUM(INDIRECT(B12&"!$J$39"))
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
Bookmarks