Hi,

I'm trying to figure out how to do a sumif or sumproduct between two different workbooks. Originally, I used the sumif formula, but when I closed one workbook, the other workbook with the sumif formula would show #Value! error. I know that you can use the sumproduct formula to fix this problem, but I can't seem to get the sumproduct formula to work correctly. I have tried different ways of writing the sumproduct formula, but it still gives me the #Value! error.

Here's one of my sumproduct formula between two different workbooks:

SUMPRODUCT(--('[2014 Strat Plan HR Investments.xlsx]PO Investment'!$C$13:$D$54=$C8),'[2014 Strat Plan HR Investments.xlsx]PO Investment'!Z$13:Z$54)

Workbook 1: 2014 Strat Plan HR Investments v2 - test.xlsx (this is where I want the sumproduct formula to be)

Workbook 2: 2014 Strat Plan HR Investments.xlsx (this is where I want the value to pick up)

Any help is appreciated!

Thanks