1(L)(2)(1)(W)(0)(0)
2(W)(1)(1)(W)(0)(0)
3(L)(2)(-1)(L)(50)(30)
4(W)(2)(1)(W)(0)(0)
5(L)(4)(-1)(L)(30)(30)
6(L)(2)(-1)(L)(10)(30)
如果
A column一定是(L),同時
B column 一定是(2),同時
C Column一定是(-1),即第三和第六列符合資格,只要有一列合資格,便需要計算D column 之L在E column之總和,再除D column 之(L)出現總和,然後在FColumn 計算在D column 出現L,(答案是 (50+30+10)/3=30 )、
如果無同一列有ABC column是L,2,-1,
0(A)(B)(C)(D)(E)(F)
1(L)(2)(1)(W)(0)(0)
2(W)(1)(1)(W)(0)(0)
3(L)(3)(-1)(L)(50)(50)
4(W)(2)(1)(W)(0)(0)
5(L)(4)(-1)(L)(30)(30)
6(L)(2)(1)(W)(0)(0)
便於F column 等於E column之數值,
請問F Column之算式怎麼寫?
You right 是一個問題,用=IF(B1&A1&C1="2L-1",SUMIF(D:D,D1,E:E)/COUNTIF(D:D,D1),E1) 算式 OK,但 改位置就做不到? //(E)(F)(G)(H)(I)(J) 6(L)(2)(1)(W)(0)(0) 7(W)(1)(1)(W)(0)(0) 8(L)(3)(-1)(L)(50)(50) 9(W)(2)(1)(W)(0)(0) 10(L)(4)(-1)(L)(30)(30) 11(L)(2)(1)(W)(0)(0)
ignore the supplement of 2242 hrs. 0(A)(B)(C)(D)(E)(F) 1(L)(2)(1)(W)(0)(0) 2(W)(1)(1)(W)(0)(0) 3(L)(2)(-1)(L)(50)(30) 4(W)(2)(1)(W)(0)(0) 5(L)(4)(-1)(L)(20)(30) 6(L)(2)(-1)(L)(20)(30) 是一個問題,Sorry, 我誤到你,現將E5&E6改為20,你會明白我意思。
補充 2355hrs.
是一個問題,Sorry, 我誤到你,現將E5&E6改為20,你會明白我意思。要變成上述FColumn answer,當出現ABC column 同時出現L2-1,就要E column 之Total 數(50+20+20=90)除去D column 出現之L次數(L+L+L=3),再平均分配於F column 所屬D column 之 L(F3, F5, F6, =30)