I want to calculate the difference between every cell in one primary row to other rows and then sum the diff.
Primary row: - [11,19,59,69,9]
other row: - [10,20,30,20,50]
diff - [|11-10|,|19-20|,|59-30|,|69-20|,|9-50|] = [1,1,29,49,41]
sum(diff) = 1 + 1 + 29 + 49 + 41 = 121
How can i do it ?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire