SumIF returning #VALUE! when referenced workbook is closed

Hi,

My SUMIF function only works when the workbook that I'm referencing to is open. When it's closed and I open the file it shows #VALUE!.
How do I fix this problem?

Thanks.

Yes, some functions like Sumif, Countif, Indirect, etc.. do not work with closed workbooks. Try Sumproduct...

for example, in G2:

Please Login or Register  to view this content.