Hello,
I find this question difficult to describe in words, so I hope this will do the trick:
I have binary data in four columns: A, B, C and D. These are arranged in rows (a large number). In a fifth column, S, I want to Sum all the 1's in a given column (A, B, C or D), thereby obtaining a "column height" for each set of 1's.
The output would look something like this:
A B C D S
0 1 0 0 1
1 0 0 0 2
1 0 0 0 2
0 0 1 0 1
0 1 0 0 1
1 0 0 0 1
0 1 0 0 1
1 0 0 0 3
1 0 0 0 3
1 0 0 0 3
0 1 0 0 1
0 0 1 0 4
0 0 1 0 4
0 0 1 0 4
0 0 1 0 4
You can hopefully see better from the example than my explanation what I am trying to achieve. Columns A, B, C and D are the input, and Column S is what I am trying - and currently failing - to calculate.
Any help gratefully appreciated !
Thank you for taking the time to read this, whether or not you can help.
Rob
Bookmarks