Hiro 714
asked on
How to count a value in external files in Excel
ASKER
Okay. How about this?
=SUMPRODUCT(CONCATENATE("(","'",F3,"[",A3,"]","sheet1'!$B$1:$B$1000=B$2)*1)"))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try replacing that part (red and blue boxes) of the code with this:
Open in new window