# Simplifying a column of values

1. ## Simplifying a column of values

Wonder if someone could solve this? I have a two column of hundreds of mouse movements and I'd like to reduce the number of steps. Every three rows I need to sum those rows and display the results in the C and D columns. It shouldn't matter too much if the last three elements contain zeros. The attached file shows the general idea. I have no idea how to accomplish this and would appreciate any help, thanks.

2. ## Re: Simplifying a column of values

You can use this formula in cell C1:

=SUM(INDEX(A:A,(ROWS(\$1:1)-1)*3+1):INDEX(A:A,ROWS(\$1:1)*3))

Copy it into D1 (so that the range changes from A:A to B:B), then copy both formulae down as far as you need them.

Hope this helps.

Pete

3. Thanks Pete
Ill give that a try..
Next challenge will be to make a VBA version so that I can adapt it to different drawings!

4. ## Re: Simplifying a column of values

A very simple, easy to understand and easy to change to suit your needs one.
``Please Login or Register  to view this content.``

5. ## Re: Simplifying a column of values

Thank you jolivanes. It works out of the bag, and I think I can guess how to modify the values. Thank you very much !!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1