ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

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

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

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

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

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

TOP

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

TOP

¦^´_ 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..

TOP

¤Ó·PÁ¤F

TOP

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

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD