The following table was dropped into Excel using an Access module. I need to sum the entire amount column and run Excel's IRR function to determine the returns.

Date Transaction Amount
12/31/1998 Capital Contribution ($3,000,000.00)
12/31/1999 Distribution $1,036,000.00
12/31/2000 Distribution $1,200,000.00
12/31/2001 Distribution $925,000.00
12/31/2002 Distribution $646,000.00
9/30/2003 Distribution $4,700,000.00
$1,700,000.00
Desired total column $5,507,000.00 35.66

Current Code exerpt
' Sum range of cells
Sheet.cells(j, i).Value = Sheet.range("C20").Value +
Sheet.range("c25").Valu

Can anyone show me how to reference ranges and create the desired output

Thanks, in advanc

Forrest