Problem in totalling columns in excel due to format issue

I have a large database containing two files and I am trying to merge them through "Index , match" function and then sum up values in a resultant column. The data from both files is from a PDF file c...