counting how many elements of a specific column of an array starts with letters “ZS”

i have a multidimensional dynamic array with 11 columns. how do i count how many elements in column 4 starts with “ZS” (there can be items with no value, other with “ZC973279473” and others with “ZS5367276”. i care only about the one like “ZS773746”.) i tried with XNSites = Application.Count(Application.Match(Left(myarray.Columns(4), 2), “ZS”, 0)) and XNSites…

Details