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..