Hi,

I would suggest that you consolidate all the data in one worksheet first and
then use the SUM() function. Since the cell is not the same on all the
worksheets, please make use of Data Consolidate to bring all info on one
worksheet.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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!