I am trying to calculate an IRR with a sequence of positive and negative cash
flows in sequential cells, (e.g. IRR(A14:A26) but at the end of the sequence
I want to add the NPV of the equipment for a future stream of income. I have
calculated this seperately but can't seem to add it to the IRR calculation.

I've tried IRR(A14:A26+Sheet1!G11) and IRR(A14:A26,Sheet1!G11) but neither
seem to work. What am I missing?