Does any sheet have a #value error in B2?

ps. I like to insert a couple of sheets. I put one to the far left (named
Start) and one to the far right (Named End).

Then I can use:
=sum(start:end!b2)

And drag the real sheets into and out of that "sandwich" to play what-if games.

wrote:

Thank you, I'll try those.
I've tried the =SUM(Sheet1:Sheet16!B2) but for some reason it won't
work. It just comes up as #VALUE and I can't figure out why?

--

Dave Peterson