I have a project table to record time worked on projects each day
DayOfWeek: contains the number of hours worked on SUN, MON ...
SET: contains the Project Id

NAME | SUN | SET | MON | SET ...
--------|-------|------|-------|-------
John | 8 | set1 | 8 | set2
Jane | 10 | set3 | 8 | set2

Is it possible In VBA (or Excel spreadsheet) to produce this result
SET | TOTAL
------|---------
set1 | 8
set2 | 16
set3 | 10
...