Here is a small example I was given when I needed to do something og this sort. It display the total in a textbox though not a column. Hopefully it will get you on the right track.

CalcDGVColumn.zip