The following has me scratching my head and i am anxious for any help to obatin the results that i need.

From a long list of date as shown below how do i calculate totals for each day of the week. Below is a small example of the data that i have.

I want to establish totals for each monday for example for the long list of data that i have spanning 200 days.

Aprpeciate any help that someone can give on this


08-Apr 09-Apr 10-Apr 11-Apr 12-Apr 13-Apr
0 129 123 114 0 138