Sum Across Multiple Worksheets, Showing No Zeros

I am trying to add the same cells from multiple worksheets into a master worksheet. Seems easy enough, but numbers haven't been put into cells, I need my master worksheet to stay blank until a number is added to anyone of the worksheets. Right now my master worksheet has:

=SUM('Sheet1:Sheet25'!B26)

Which, obviously, works unless there is nothing input into cell B26 on any worksheet. Then it shows on the master as a zero. Besides just clicking 'show zero values', is there a formula to make it so that zero doesn't come up in my master worksheet? I am having trouble understanding SUMIF across multiple worksheets and I'm not sure it would be the right formula anyway.

The reason this is important is because I have a message that pops up if there is actually a zero in any of the cells marked B26. I need to be able to distinguish where there is a blank and where there is a zero. I hope this is clear. Please let me know if I can explain any better

Any suggestions?

Try:

Please Login or Register  to view this content.

Well, that seemed a lot easier than I thought it was. It was the 'count' that I didn't think to use. I really appreciate you working on my problem. My spreadsheet is now complete. Thanks so much mcmay!!

@ Girthicker

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.