Google-sheets – Trying to query a range of names in Google Spreadsheets, query is failing with the space in the names

The data summary that you are trying to build, some people call them "crosstab report" or "pivot table".

Google Sheets, have at least two easier than the complex formula in the question ways:

1. QUERY function using the GROUP BY and PIVOT keywords. See QUERY for details.
2. Pivot Table report. See How to create a pivot table report for details.

The error message is due to a missing closing parenthesis before the first AND.

Once solving this, you will get as result the following

            sum     sum 
10/12/2016  296.1   2.5

To avoid the headers, before the last " add

 label sum(Col8) '', sum(Col9) ''

the final formula is

=QUERY(ARRAYFORMULA(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/1Wyewpz0j_IiKK8ESOapX5L4AedjvHccLZOOKS2tZGUA/",
"UsuallyAnotherSpreadsheetFile!B2:K")),"Select Col4, sum(Col8), sum(Col9) where  
(Col4=date '"&TEXT(A14,"yyyy-mm-dd")&"') AND (Col3='" & $F$1 & "')  AND 
(Col1 = '" & ClientInfo!$H$1 & "') group by Col4 label sum(Col8) '', sum(Col9) ''")