# counting across complementary columns

2 views (last 30 days)
Wesso on 17 Mar 2019
Edited: Guillaume on 18 Mar 2019
I wrote a long function (attached so that you know it is not a post by a lazy student seeking an answer for his assignment) nd then I sensed that what I wrote is long and rediculous and coule be full of mistakes (still incomplete). I hope you can help
In short I have column A(daily date numbersover 4 years) and 5 columns that i want to count. Column B is always 1 and it is equals to the sum of rows in columns C,D,E, and F. So, Column C, D, E,F are complementary: if row C=1,rows D,E,and F must be zeros;if row D=1,rows C,E,and F must be zeros;if row E=1,rows C,D,and F must be zeros;and finally if row F=1,rows C,D,and E must be zeros;
How can do the counting in two ways
1. count the number of observations in columns B,C,D,E, and F for every day of every month of every year
2. count the number of observations in columns B,C,D,E, and F for every month of every year
I feel that it is much easier to compute than reporting a long fucntion with loops. I appreciate any assistance.
##### 2 CommentsShowHide 1 older comment
Guillaume on 17 Mar 2019
Please give an example of input and desired output, preferably using valid matlab syntax as comments to the question.

Wesso on 18 Mar 2019
i will stick to b since it is more important to my analysis:
Wesso on 18 Mar 2019
i don't know why column F doesn't appear in the image although in the original image it does. I am upliading an excel file as well