Schema: CREATE TABLE table_name_26 (attendance VARCHAR, opponent VARCHAR)
Question: When Hamilton Academical is the Opponent, what is the total Attendance?
SQL: SELECT COUNT(attendance) FROM table_name_26 WHERE opponent = "hamilton academical"