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