sum(if( function where the argument logical_test contains arrays

Originally Posted by daddylonglegs

I'm not sure what that means, what is "present value" in the context of the values shown here?

Try this formula to simplify your original

=IF($B15<=$B$4;SUMPRODUCT((SettlDate_Blotter=$B15)*(Securities_Blotter=HM$13);Contracts_Blotter;TradePrice_Blotter)/IF(BG15=0;1;BG15);0)

Hi,
Thanks for the simplified formula.
By present value I meant that, in cases where SettleDate_Blotter is different than TradeDate_Blotter, that is, when the security is traded today, but only settled tomorrow, this result should be multiplied by [1/(1+ daily interest rate)].
What I'm trying to figure out is a way of nesting this additional IF() function, which separates the lines in sheet 2 where the value in the vector TradeDate_Blotter is different than the one in the other vector, SettlDate_Blotter.
Of course the IF() function demanding that $B15 equals SettlDate_Blotter should remain active.

So, if $B15=SettlDate_Blotter, but SettlDate_Blotter is different than TradeDate_Blotter, the result should be multiplied by the discount factor. Otherwise, not.

Not sure if I'm making myself clear enough. It's pretty hard for a non-native speaker.

Many thanks in advance