Thread: Counting data from an external workbook
View Single Post
 
Old 05-23-2018, 08:35 AM
Roger Govier Roger Govier is offline Windows 10 Office 2016
Novice
  
Join Date: Oct 2017
Location: Abergavenny, Wales, UK
Posts: 13
Roger Govier is on a distinguished road
Default
Hi

I think you need to also coerce your Lefts from Text values to Numbers and, your second part I think the test should be = and not <>

Code:
=SUMPRODUCT(--(--LEFT([workbook.xlsx]Sheet!$A1:INDEX([workbook.xlsx]Sheet!$A:$A, MATCH("zzz", [workbook.xlsx]Sheet!$A:$A)), LEN(C1))=C1),
            --(--LEFT([workbook.xlsx]Sheet!$A1:INDEX([workbook.xlsx]Sheet!$A:$A, MATCH("zzz", [workbook.xlsx]Sheet!$A:$A)), LEN(D1))D1))
Reply With Quote