I figured it out but i still think M$ needs to make this easier in thier next version of ASP.Net.Here is how i did it.
Dim total_amtpaid As Decimal Dim total_disc As Decimal Dim total_fs As Decimal Dim total_assl As Decimal Dim total_Net As Decimal Dim total_Weight As Decimal Protected Sub TotIncurGrid_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound 'Sum Columns If e.Row.RowType = DataControlRowType.DataRow Then total_Weight += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Weight")) total_Net += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Net")) total_assl += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Accessorial")) total_fs += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "FS")) total_disc += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Disc")) total_amtpaid += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "AmtPaid")) ElseIf e.Row.RowType = DataControlRowType.Footer Then e.Row.Cells(9).Text = "<strong>Totals:</strong>" ' for the Footer, display the running totals e.Row.Cells(10).Text = total_Weight.ToString("n0") e.Row.Cells(11).Text = total_Net.ToString("c") e.Row.Cells(12).Text = total_assl.ToString("c") e.Row.Cells(13).Text = total_fs.ToString("c") e.Row.Cells(14).Text = total_disc.ToString("c") e.Row.Cells(15).Text = total_amtpaid.ToString("c") e.Row.HorizontalAlign = HorizontalAlign.Right e.Row.Font.Bold = False e.Row.Font.Size = 9 End If End Sub