[问题] averageif条件递增

楼主: alwayslone (小月半子)   2020-02-19 16:36:12
各位版上高手,请问我有一个
averageif(k$2:k$200,"10",m$2:m$200)算式
请问要如何下拉让它条件递增0.5变成
averageif(k$2:k$200,"10.5",m$2:m$200)
averageif(k$2:k$200,"11",m$2:m$200)
.
.
.
感谢各位高手指教!谢谢
作者: soyoso (我是耀宗)   2020-02-19 16:41:00
"10"改为10+(row(a1)-1)*0.5或是改为row(a20)/2

Links booklink

Contact Us: admin [ a t ] ucptt.com