your post title says sum if formula. Your second and third posts seem to be refining your results but you haven't uploaded a new sheet which should account for any changes.
Are you looking for a vlookup formula that would return the value in column C of the manual 1 tab that "matches" the value in the reed 96 tab of column F? In other words simply a match between 90*100 and the 2.45 brought over from manual 1 to populate in K116?