Hi Again,

I have a solution to return the result to a blank cell instead of 0/01/1900. a little long winded so if there is a better alternative, please let me know (good for learning curve)

if used an IF statement.

=IF(SUMPRODUCT(--(INDEX(Other,0,1)=$A32),--(MONTH(INDEX(Other,0,2))=MONTH(G$1)),INDEX(Other,0,2))=0/1/1900,"",SUMPRODUCT(--(INDEX(Other,0,1)=$A32),--(MONTH(INDEX(Other,0,2))=MONTH(G$1)),INDEX(Other,0,2)))

Thanks again to xld for your expertise.....