小弟想請教一個EXCEL自動填滿的問題
我的儲存格AF38有一筆公式
我希望能夠透過EXCEL滑鼠黑色十字箭
往下拉自動填滿公式
變化成以下範例
需要如何操做及修正才能辦到呢？
範例
儲存格AF38=COUNTIF(B$3:B$33,">67.5")-COUNTIF(B$3:B$33,">112.5")
儲存格AF39=COUNTIF(C$3:C$33,">67.5")-COUNTIF(C$3:C$33,">112.5")
儲存格AF40=COUNTIF(D$3:D$33,">67.5")-COUNTIF(D$3:D$33,">112.5")
儲存格AF41=COUNTIF(E$3:E$33,">67.5")-COUNTIF(E$3:E$33,">112.5")
儲存格AF42=COUNTIF(F$3:F$33,">67.5")-COUNTIF(F$3:F$33,">112.5")
簡化而言就是讓ＡＢＣＤＥＦ可自動遞增
拜託各位不吝協助
小弟真的找不到方法
