Windows XP Summing up specific rows

L

lerashe

Joined
Feb 1, 2007
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embarrassing question about lookup. 4
Always Display value in active cell cell x-rows above it ? 1
Smaller VBA? Loop or Offset? 3
Function Bug ? 8
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13
Concatenate problem 7
Help: How do I create a column of fixed width data? 1
critera search in FP DB 2

Top