[問題] 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