Can an array be made of discontinuous cells of the same row?
 

I have used array formulas in other spreadsheets with success, but when i try
to use one now where the elements of the array are in discontinuous cells of
the same row I get a value error? Are array elements required to be
continuous cells only?