How do I add Certain items in a array

[jonh]

To sum rows you use grouping and sum().
To sum columns you just add them together.

SELECT ID, Sum(Value1), Sum(Value2), Sum([Value1]+[Value2]) AS Total
FROM Table1
GROUP BY ID