Somehow this formula it's not working and i can't figure out why.


=B4-I4-J4-(SUMIFS([Inventory2014.xlsx]Inventory!F:F;[Inventory2014.xlsx]Inventory!A:A;$A4))


B4 it's 10€
I4 it's 0,71€
J4 it's 0,44€

and A4 on SUMIF it's 2,39€.

Shows me a result 8,85€, somehow it's not subtracting A4.

It's supposed to be 6,46€.


I'll post the workbooks on this thread:

Sales2014.xlsxInventory2014.xlsx