=COUNTIF(Sheet1!$A$1:$A$4,"="&A1)+COUNTIF(Sheet2!$A$1:$A$4,"=...
=IF(A2=1,"正",IF(A2=2,"負",IF(A2=3,B1,)))
請提供dhcp server / gateway ip.
admy6307的鐵人檔案