Seperating data from one column

[FLChamp]

Hello, I hope someone can help.

I have a single column that contains a list of numbers but the numbers actually represent two different things so I want to sum them seperately. An example might help.

Number 1
Number 2
Number 3
Number 4
Number 5
Number 6

So in the above example I want to sum Numbers 1, 3 and 5, and then sum Numbers 2, 4 and 6. The length of the column is about 2000, but some rows are blank, and there is no regularity in the occurances of the blank rows, and the position of the blank rows could change next week when I have a new set if data.

Any ideas on how to achieve this task?

Many thanks in advance

 

[Greg Truby]

Welcome to the board. If you want to sum odd rows or even rows, that's certainly possible. Is this what you want? Otherwise, you need to better describe the criteria that is used to determine which cells need to be summed.

 

[FLChamp]

Its more complicted than just distinguishing between odd and even rows. The positions of the cells belonging to the two datasets within the column are random, but they do have a consistant relative position. There is a text heading first, then two numbers, followed by a random amount of blank rows. So it looks somthing like this

Text (heading)
Number (From set 1-to be summed)
Number (From set 2-to be summed)
Some blank cells
Text (heading)
Number (From set 1-to be summed)
Number (From set 2-to be summed)

and this then repeats...

Thanks