reviewed the worksheet, user wants to add cells from separate worksheets adding zero value where null.
i suggested the following but thought somebody might be able to suggest more succinct formula...
=if(isnumber('sheet1'!a1),'sheet1'!a1,0)+if(isnumber('sheet2!a2),'sheet2'!a2,0)+...etc