SUMIF won't work on closed files. Better to use SUMPRODUCT.

Biff

"bj" wrote in message
...
try something like
=Sumif('Woorkbook1.xls]Sheet1'!A:A,"<='[Woorkbook2.xls]Sheet2'!A51,'Woorkbook1.xls]Sheet1'!C:C)-Sumif('Woorkbook1.xls]Sheet1'!A:A,"'[Woorkbook2.xls]Sheet2'!A50,'Woorkbook1.xls]Sheet1'!C:C)

"Will" wrote:

ok I cand understand the answers to other similar topics posted here so i
am
going to have to try to explain my self...

I have two .xls sheet (WorkBook1 & Woorkbook2)

In Woorkbook1 on Sheet1 I have in column A incrementing dates...
In Woorkbook1 on Sheet1 I have in column B Total Run Time...

In Woorkbook2 on Sheet2 I have in cell A50 the START date...
In Woorkbook2 on Sheet2 I have in cell A51 the END date...

I am looking for a furmula that will sum the run time between and
including
the START and END dates.

I have succeded in having the formula return a value for a single date
but
not for the sum of the values found winthin a date range...