How to create a spreadsheet that computes the cumulative annual rate of return of individual investments, the subtotal of a group of investments and the total of all investments.

The rows should be time and columns the investments. Cells would contain either inflows (sales, dividends, interest) or outflows (purchases, dividend/interest reinvestments).

What Excel function should I use?