Multiple look ups with multiple criteria

[Sthomson1984]

Hey guys,

Am trying to work out an automatic cash flow based on invoice date and payment terms.

I've attached an example with the desired formula result in cells C2:I2.

Can anyone shed some light on this?

[samba_ravi]

c2=SUMPRODUCT((COLUMN(C$2)-COLUMN($C$6:C$10)=CEILING($B$6:$B$10/30,1))*($C$6:C$10))

Please Login or Register  to view this content.

Try this and copy towards right

[Sthomson1984]

Awesome, thanks heaps.