Cells(i,4) = "=countif(range(cells(2," & ampj+2 & amp;”):單元格(268,“& ampj+2 & amp;”)、單元格(& amp我& amp",3))"
方法二:
單元格(I,4) =應用程序。WorksheetFunction.CountIf(範圍(單元格(2,j + 2),單元格(268,j + 2)),單元格(I,3))