Sherry S wrote:
Hi all,
I am trying to learn this as I go.

I have 31 speadsheets all in the same workbook to represent the days in the
month of January. They are exactly the same except the dates. I want to take
the grand totals from each one and place it on #32 sheet for an end of the
month total. The way i have the formula written right now gives me a #ref
error.

=JAN1!C26+JAN2!C26+JAN3!C26+JAN4!C26+JAN5!C26+JAN6 !C26+JAN7!C26+JAN8!C26+JAN9!C26+JAN10!C26+JAN11!C2 6+JAN12!C26+JAN12!C26+JAN13!C26+JAN14!C26+JAN15!C2 6+JAN16!C26+JAN17!C26+JAN18!C26+JAN19!C26+JAN20!C2 6+JAN21!C26+JAN22!C26+JAN23!C26+JAN24!C26+JAN25!C2 6+JAN26!C26+JAN27!C26+JAN28!C26+JAN29!C26+JAN30!C2 6+JAN31!C26

It did work on a smaller scale on a practice file. But not on this file.



A couple thoughts.

First, see if this technique works on your #32 sheet. Sum column B for
the final answer:

A B
Sheet SubTotal
1 =INDIRECT("JAN"&A2&"!C26")
2 ...fill down...
etc.


Other thought is, if all the worksheets "are exactly the same except the
dates" you could spare a lot of effort by consolidating the data onto
one worksheet with an added column for the date. This makes things like
getting monthly totals much simpler.