Take a look at the XNPV function which calculates the Net Present Value of a
stream of irregular cash flows.

I think that'll do what you're looking for.

Regards,
Ron