Hi, Is there some way wherein I can use the XNPV function as a general formula for a set of cells? To get the value of XNPV, the selected cells should only be the ones with values in it. But the other cells are cash flows which changes whenever I change the date, so I have to move the selected cells again to get the value. Is there some way where the formula ignores the other selected blank cells? Thanks so much!excel.png