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,"")
I have just realized my answers are not coming out correctly either.
That's because a sum total of 0 is not an error.
I assume you want a blank?
=IFERROR(1/(1/SUM('Week 1:Week 12'!B$6:B$9)),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
=IFERROR(IF(('Week 1'!C$6:C$9+'Week 2'!C6:C9+'Week 3'!C$6:C$9+'Week 4'!C$6:C$9+'Week 5'!C$6:C$9+'Week 6'!C$6:C$9+'Week 7'!C$6:C$9+'Week 8'!C$6:C$9+'Week 9'!C$6:C$9+'Week 10'!C$6:C$9+'Week 11'!C$6:C$9+'Week 12'!C$6:C$9)=0,"",'Week 1'!C$6:C$9+'Week 2'!C6:C9+'Week 3'!C$6:C$9+'Week 4'!C$6:C$9+'Week 5'!C$6:C$9+'Week 6'!C$6:C$9+'Week 7'!C$6:C$9+'Week 8'!C$6:C$9+'Week 9'!C$6:C$9+'Week 10'!C$6:C$9+'Week 11'!C$6:C$9+'Week 12'!C$6:C$9),"")
Yes that is correct, I would like the cell to remain blank if no value is provided. This formula worked perfectly.
Thank you as well Shareez
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks