Select A1.
    From the menu, select the Data tab, Text to Columns, and you will get a wizard.
    First screen, select Delimited, then Next.
    Second screen, select Space, then Next.
    Third screen, for the Destination put D1, then Finish.

=1*(D1=D2)-ISBLANK(D1)

=SUM(D3:R3)/COUNTA(D1:R1)