Please check these posts for the same problem:

http://groups.google.com/group/micro...fe7a93fe087156


The last post is :

"The original Sumif is looking at the same cells and brings back a
value when
the other workbook is open so that can't be it.

Woohoo, it appears that column e wasn't a value, I changed it to be a
value
and it works. I can't believe it was such a simple fix. I didn't
think the
normal =sumif() would work if it wasn't a value.


You're a genius.


Thanks heaps. "



I do not get the solution to the problem. What exactly does he mean
when he changed column E to be a value?