Hello again, i tried to experience with external data as a reference formula but i am stuck at finding the right function.
I've triend to use count and sum and it is working fine.
This two function works fine,
=SUM([sales.xls]Sheet1!C2:C20)
=COUNT('C:\Users\test\Downloads\[sales.xls]Sheet1'!B1:b21)
But when i tried to combine using the formula like this
=$I$4-SUMPRODUCT(($M$4:$M$100=$H$4)*($N$4:$N$100)) (working formula)
=$I$4-SUMPRODUCT(($M$4:$M$100=$H$4)*('C:\Users\test\Downloads\[sales.xls]Sheet1'!N4:N100)) (error).
Do you have any idea how to solve this?