�u�a�`�Ń��N�� `Part 1�`

�}�N��ł��I �` Excel��pHomePage �`

�u�a�`�Ń��N�� `Part 1�`

��̃R�[�i�[�ł́A�u�a�`�̎g��𒆐S�ɂ��Љ�Ă��܂��B
��Ҏ��g�̌o��珑��Ă��܂��̂ŁA�{�Ƃ��Ƃ͈��R�g��
��Ă�g�R��邩��܂��B ��ꍇ�́A�ǂ��ȕ��M��܂��傤(^_^;

TOP �� u�a�`�Ń��N�� `Part 1�` �� ϓ��f�[�^�ւ̑Ή��i��̂T�j

�ϓ��f�[�^�ւ̑Ή��i��̂T�j

��đO��̏h��̉𓚂��Q��܂��傤��B

�Z��B1�� =SUM(C1:E1) ��Ă��B
�Z��A5�� =SUM(A7:A9) ��Ă��

��ꂼ�ꑊ�ΎQ�Ƃɒ��Ƃǂ��Ȃ�ł��傤��H �Ƃ��₢�ł��A
�ǂ��ł��H
�𓚂�
1."=SUM(RC[1]:RC[3])"
2."=SUM(R[2]C:R[4]C)" �ƂȂ�܂��B��ۂɃ}�N��̋L�^�Ŋm��
�Č��Ă��B��ΎQ�Ƃ̕��͋C�͂Ȃ�ƂȂ��肢��
�ł��傤��B

�ȏ�̂��Ƃ𓥂܂�� "=SUM(R[-" & Gyo & "]C:R[-1]C)" �̕��
�̈Ӗ��ɂ��čl��Ă݂܂��傤�B

�ŁA��̕��ł��ǑO�Ƀ`��Ƃ��܂��ˁB"��̘A��"��
��Ă��܂��B��`��ƃ`��b�g��Â炢��܂��񂪁A��
�� "=SUM(R[-" �� ϐ� Gyo �� "]C:R[-1]C)" �� & �łȂ�
�ĂP�̕��ɂ��Ă��܂��B�Ⴆ�΁A�ϐ�Gyo�̒l��T�ł��΁A
"=SUM(R[-5]C:R[-1]C)" �Ƃ��ɂȂ�܂��B��Č��
��܂��ˁH�Ȃ�ł��ȕςȕ��̎w�肪��̂��B��
��肽��̂ł��A�n�C�B

�Ō�̍s�̈Ӗ��͂��ł��肢��Ǝv��܂��B
�ϐ� Gyo�̒l��Ă��̂́A��ł̓f�[�^��̍s��A�܂�f�[
�^��܂��B�f�[�^��T�ł��"=SUM(R[-5]C:R[-1]C)"
�ł��ˁB��̎��͌��݂̈ʒu��-1�`-5�͈̔͂��v��鎮�ɂȂ�
�܂��A��傤�ǑS��W�v��鎮�ɂȂ�킯�ł��B��낵��ł��
��H

��̗��Ƃ��ꂼ��̃R�[�h�̈Ӗ��Ă��܂��΁A��f�[�^
��ɐL�т悤��c�ɐL�т悤��W�v�ł��Ă��܂��܂��(^_^

�ŁA��̃P�[�X�ł�"��o��̂Ȃ��f�[�^"��O��ɂ��܂��A
��o��ꍇ�̓`��b�g��ӂ��K�v�ł��B

"��o��"��ꍇ�́A��o��S�̂̍s��Ƃ��ăJ�E��g��
�Ă��܂��܂��B�ł��̂ŁA��Ƀf�[�^��𐔂��ɂ�"�f�[�^��
��i�S�̂̍s��)��A��o��s��"�悤�ɂ��΂��̂ł��B
��̏ꍇ�Ō�̍s��
ActiveCell.FormulaR1C1 = "=SUM(R[-" & Gyo -1 & "]C:R[-1]C)"
�ƕς��΂悢�ł��傤�B

�S�̗̂��͂Ȃ�ƂȂ��ɂȂ�܂��H(^_^)
��͂��̃}�N��`��b�g��Ă݂悤�Ǝv��Ă܂��B
��ł͎��܂ł��悤�B

TOP �� u�a�`�Ń��N�� `Part 1�`

�u�a�`�Ń��N������ �`Part 1�`

�u�a�`�Ń��N�� `Part 1�`