Well, you need to 1) unpivot data then to 2) sum them.
See:
CREATE TABLE Questions
(
Question varchar(30),
Sol25A int,
Sol25B int,
Sol25C int,
Sol40A int,
Sol40B int
);
INSERT INTO Questions (Question, Sol25A, Sol25B, Sol25C, Sol40A, Sol40B)
VALUES('A', 1, 4, 2, 6, 0),
('B', 2, 3, 2, 1, 9),
('C', 6, 7, 1, 0, 8);
SELECT Solution, SUM(Points) Total
FROM
(
SELECT Question, Sol25A, Sol25B, Sol25C, Sol40A, Sol40B
FROM Questions
) pvt
UNPIVOT (Points FOR Solution IN (Sol25A, Sol25B, Sol25C, Sol40A, Sol40B)
)
AS unpvt
GROUP BY Solution;
Result:
Solution Total
Sol25A 9
Sol25B 14
Sol25C 5
Sol40A 7
Sol40B 17
Link to fiddle:
SQL Server 2019 | db<>fiddle[
^]