Any ideas or comments??

Don't use SUMIF. Use SUMPRODUCT instead.

If you're not sure how to use Sumproduct post your Sumif formula and we'll
translate it into Sumproduct.

Biff

"mpenkala" wrote in message
...
Hi all,

So I've got a new problem. Kinda like my last one, but a little easier (I
hope).

I currently have a main workbook called 'Dept OT' and Sheet1 has been
renamed 'Comms June-Dec2006'. On this sheet I have the following:
Column 'A' - Employee ID#
Column 'B' - Employee Name
Column 'C' - Total OT (Monthly June)
Column 'D' - Total OT (Yearly)
Column 'E' - Percentage OT Monthly
Column 'F' - Percentage OT Yearly

I then have a empty column and repeat the process for July, Aug, etc...
I use a SUMIF function in ColumnC to find the the information needed. The
information is located in a diffenent workbook called 'JuneOT' (JulyOT for
July, AugOT for August... etc).

JuneOT is simply names, ID#, and OT hours worked.
Column 'A' - ID #
Column 'B' - name
Column 'C' - Date
Column 'D' - Hours worked

My SUMIF simply looks for the ID#, matches it with the ID# in the DeptOT
workboot, then sums the hours worked if a match occurrs. The function
works
great - that's not my problem - it's after I save and close excel...

Once I close excel and then try to open DeptOT I get the following
message:

"This workbook contains links to other data sources.
-If you udate the links, Excel will attempt to retreve the latest data.
-If you don't update the links, Excel will use the previous information.

If I try and Update I get 2 possible problems.

1 - The workbook contain one or more links that cannot be updated.
2 - All of my SUMIF cells show #VALUE until I actually open up the JuneOT,
JulyOT...etc. and then close them again. Once this is done, DeptOT looks
and
works fine.

Any ideas or comments?? I'm lost on this. I even tried to create a macro
that would open up JuneOT, JulyOT, AugOT, etc and then close them again,
but
it always closes DeptOT as well... so I guess I'm stuck.

Thanks,
Matt