Trying to Calculate XNPV with LAMBDA

[BenBE2]

Does anyone have any idea how to do this?

XNPV goes like this:

- Rate

- CFs (this is a moving range as the formula is dragged) ex. A1:A1 then A1:B1

- Dates (Moving range as the formula is dragged) ex. A2:A2 then A2:B2

I think i use the Map function but I can quite get it to work. Can anybody assist?

[#2]

@BenBE2 

Perhaps something like this

which you may customize and wrap by lambda

[#3]

This is a solid idea. I'll give it a shot!