formula

  • Thread starter Thread starter wlfranks
  • Start date Start date
W

wlfranks

=SUM('Oct 1'!C42+'Oct 2'!C42+'Oct 3'!C42+'Oct 4'!
C42+'Oct 5'!C42+'Oct 6'!C42+'Oct 7'!C42+'Oct 8'!C42+'Oct
9'!C42+'Oct 10'!C42+'Oct 11'!C42+'Oct 12'!C42+'Oct 13'!
C42+'Oct 14'!C42+'Oct 15'!C42+'Oct 16'!C42+'Oct 17'!
C42+'Oct 18'!C42+'Oct 19'!C42+'Oct 20'!C42+'Oct 21'!
C42+'Oct 22'!C42+'Oct 23'!C42+'Oct 24'!C42+'Oct 25'!
C42+'Oct 26'!C42+'Oct 27'!C42+'Oct 28'!C42+'Oct 29'!
C42+'Oct 30'!C42+'Oct 31'!C42)is there an an easier way
to do this formula?
 
Echo Domenic's solution, provided that the worksheets are adjacent, by which
I mean with no other worksheets within the range that are called something
else: in that case the simple formula will evaluate, but not necessarily to
the correct value.

If there is a risk that the relevant worksheets are not adjacent, or you
need to test for any one or more of the worksheets containing an error value
in the tested cell, then take a look at the thread with subject header:
"Using SUM and getting #Value!"
in the newsgroup microsoft.public.excel.programming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top