Ok, so fill in the details.

What is the format of your sheet names?
Jan, Feb, Mar etc?
January, February, March?
1-09, 2-09, 3-09?
Jan 09, Feb 09, Mar 09 ?

Where is this data?

SUMIF based on what condition?

--
Biff
Microsoft Excel MVP


"EricSHEM" wrote in message
...
I have a spreadsheet with 12 worksheets, one for each month. I would like
to
be able to use a 13th worksheet to add amounts from all 12 pertaining to a
date range specified on each sheet. I've tried sumif but the formula
would
be VERY long and complex.

Thanks!