Hi all,
Does anyone know if there's a way to turn something like this:
I M R SUM
2 7 1 10
a 2 2
a 3 3
b 1 1
c 4 4

into this:

I M R SUM
2 7 1 10
a 2 3 0 5
b 0 0 1 1
c 0 4 0 4

I, M, R are column headers, and a, b, and c are data. Just below the column
headers is the sum for all the rest of the values in the column. I'm not
very good at macros, so if the solution is a macro would you mind telling me
how to implement it?
Thanks so much!