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