Table 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"