close

i have to add cells evenly spaced, eg a1 a11 a21 ... a991
how can I avoid writting all references?

Try something like this:

For a list of numbers in Col_A

B1: =SUMPRODUCT((MOD(ROW(A1:A1000),10)=1)*A1:A1000)

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;mcutlacquot; wrote:

gt; i have to add cells evenly spaced, eg a1 a11 a21 ... a991
gt; how can I avoid writting all references?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄