CREATE TABLE table_204_467 (id NUMBER, "date" CLOB, "opponents" CLOB, "h/a" CLOB, "result\ f-a" CLOB, "scorers" CLOB, "attendance" NUMBER)

number of goals manchester united scored against preston north end in the season
SELECT SUM("result\nf-a") FROM table_204_467 WHERE "opponents" = 'preston north end'
SELECT SUM("result\nf-a") FROM "table_204_467" WHERE "opponents" = 'preston north end'