計算D,G兩欄差值的絕對值的總和
=SUMPRODUCT(ABS(D213:D242-G213:G242))/(MAX(D213:D242)-MIN(G213:G242)+1)*100
- Jun 21 Sat 2008 09:15
-
計算兩欄差值的絕對值的總和