Hi,
I am trying to sum values of specific rows like C5,C9,C13,C17. The rows to be added increases by 4. The result shud be displayed in C19.
C5 - 1 , C9 - 3, C13 - 2, C17 - 4. Result C19 : 10.
My problem area is
In case if i add 4 more rows before C19.
I want cells: C5, C9, C13, C17, C21 to be summed up and the resultant to appear on C23.
How do i go about with this.
Help me guys.
Thanks,
Sherline.
I am trying to sum values of specific rows like C5,C9,C13,C17. The rows to be added increases by 4. The result shud be displayed in C19.
C5 - 1 , C9 - 3, C13 - 2, C17 - 4. Result C19 : 10.
My problem area is
In case if i add 4 more rows before C19.
I want cells: C5, C9, C13, C17, C21 to be summed up and the resultant to appear on C23.
How do i go about with this.
Help me guys.
Thanks,
Sherline.