Hi bicas,
Assuming you have this data in Column A, use following in column B and drag it down:-
=VALUE(SUBSTITUTE(TRIM(MID(A2,SEARCH("//",A2)+2,(SEARCH("EUR",A2)-SEARCH("//",A2)-2))),",",""))
Now for Debit sum, use following formula:-
{=SUM(IF(ISNUMBER(SEARCH("DEBIT",$A$2:$A$15)),$B$2:$B$15,""))}
and for Credit sum, use following formula:-
{=SUM(IF(ISNUMBER(SEARCH("CREDIT",$A$2:$A$15)),$B$2:$B$15,""))}
Debit and Credit formula are array ones and need to be entered using shift+ctrl+enter key combination.
I hope this solves your issue.
Regards,
DILIPandey
<click on below 'star' if this helps>
Bookmarks