I'm attempthing to sum several cells over 12 worksetts name Week 1 through Week 12, the equation is coming out correctly when it has a value to sum, but if the cells are empty it is showing a 0.
IFERROR('Week 1'!B$6:B$9+'Week 2'!B6:B9+'Week 3'!B$6:B$9+'Week 4'!B$6:B$9+'Week 5'!B$6:B$9+'Week 6'!B$6:B$9+'Week 7'!B$6:B$9+'Week 8'!B$6:B$9+'Week 9'!B$6:B$9+'Week 10'!B$6:B$9+'Week 11'!B$6:B$9+'Week 12'!B$6:B$9,"")
Bookmarks