½Ð°Ý:¦p¦ó¹jn¦æ¥[Á`...

a_nanami

=SUMPRODUCT((MOD(ROW(B4:B1000),2)=0)*B4:B1000)

¥H¤W¬O¹j¦C¥[Á`ªº¼gªk¡A½Ð°Ý«ç»ò§ï¬°¹j¦æ¥[Á`©O¡H

hcm19522

=SUMPRODUCT((MOD(A1:A1000,3)=1)*A1:A1000)

a_nanami

¤Ó·PÁ¤F

JBY

¦^´_ 1# a_nanami

¹j n ¦æ¥[Á`

1.  B4:B1000 : ¿é¤J¼Æ¾Ú

2.  C1 : ¿é¤J¹j¦æ¼Æ¦r

3. ¹j n ¦æ¥[Á`¤½¦¡ :

3.1 ©_¼ÆÄæ :
=SUMPRODUCT(N(OFFSET(B3,ROW(1:1000)*C1-C1+1,)))
n =2 ¥[Á` => {1,3,5,7,9¡K.}
n =3 ¥[Á` => {1,4,7,10,13¡K.}
¡K¡K¡K..

3.2 °¸¼ÆÄæ :
=SUMPRODUCT(N(OFFSET(B3,ROW(1:1000)*C1,)))
n =2 ¥[Á` => {2,4,6,8,10¡K.}
n =3 ¥[Á` => {3,6,9,12,15¡K.}
¡K¡K¡K..

a_nanami

ÁÂÁ«ü¾É!
¦A½Ð°Ý­Y¬O¹j¦h¦æªº¼gªk,¨Ò¦p: a1+a4+a7+a10+.....a100+a104...

aer

¦^´_ 1# a_nanami
¤U¦C¤½¦¡¨Ñ°Ñ

©_¼ÆÄæ
=SUMPRODUCT((MOD(COLUMN(A1:G1),2)=1)*A1:G1)

°¸¼ÆÄæ
=SUMPRODUCT((MOD(COLUMN(A1:G1),2)=0)*A1:G1)