I have kinda the same problem. I would like to sum Befareal with sumif Knude.Knudenavn and Knude_1.Knudenavn . For example, I want to sum 26111551(0,3009) with 26111551(0,0576) so the sum of Befareal is first line 0,3009, second line 0,3009+0,0576 and so on. It needs to trace the numbers that are similar and sum Befareal. It is used for a pipesystem, that are not linear. I hope it makes sense and you can help med :).