Is the "completion" column in the same location on each sheet? What column
is it? What column contians the dates? What are the sheet names? Are they
unique or do they follow some sort of pattern like: Week1, Week2, Week3 etc.
?

--
Biff
Microsoft Excel MVP


"Kgoodman" wrote in message
...
I am trying to create a formula that will allow me to sum all the values in
a
chart for a certain date. So across 5 sheets, I have a total sheet, and I
want the "January 31st" value in the "completion" column to automatically
update based on the values in "January 31st" under the "completion"
column
for the other worksheets. I know this is possible if the cells were the
same
- but they are not. Is there a way to create a formula based on searching
for
the date name?

Thank you!