XNPV
 

I am trying to to calculate the XNPV of a stream of cash flows. The problem
is that when I run differet scenarios through my model the cash flows are in
different years each time. Is there any way that I can get excel to
automatically calculate the XNPV of cash flows for only the years where my
cash flows are greater than zero or where my XNPV Dates are greater than
zero? Thanks in advance for your help!