Try:
=SUMPRODUCT((ISNUMBER(MATCH('external sheet'!$A$1:$A$4613,$A$3:$A$8,0))*('external sheet'!$D$1:$D$4613)))
Try:
=SUMPRODUCT((ISNUMBER(MATCH('external sheet'!$A$1:$A$4613,$A$3:$A$8,0))*('external sheet'!$D$1:$D$4613)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks