Hi,
I'm trying to use a conditional XIRR function.
I have tried using {=XIRR(IF($A$2:$A$7=A4,$C$2:$C$7,0),$B$2:$B$7)} but this does not work properly - see example below.
For some strage reason - it only works if the first value in column A is equal to the condition ie if you did...