- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¦^´_ 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.. |
|