Francois Bekker
New Member
- Joined
- May 28, 2015
- Messages
- 7
Please see a extract from my data set.
I would like to sum the cells adjacent to the left of the duplicates in the Service_Week Column. This means I would like to, in this example, sum (7+3) in Days_Active column and (0+0) in Wild_Moth_Count column and (9+3) in Sterile_Moth_count column. So my aim it to have one value for each Service_Week. In this case the service date and service day doesn't matter. I only need the to get the total amount of days active, Wild moth count and sterile moth count in each specific week.
Does anyone have a plan to sort out this problem please?
Kind regards
<tbody>
</tbody>
I would like to sum the cells adjacent to the left of the duplicates in the Service_Week Column. This means I would like to, in this example, sum (7+3) in Days_Active column and (0+0) in Wild_Moth_Count column and (9+3) in Sterile_Moth_count column. So my aim it to have one value for each Service_Week. In this case the service date and service day doesn't matter. I only need the to get the total amount of days active, Wild moth count and sterile moth count in each specific week.
Does anyone have a plan to sort out this problem please?
Kind regards
Trap_ID | Service_Date | Service_Day | Service_Week | Days_Active | Wild_Moth_Count | Sterile_Moth_Count |
Ajlp 1 | 2010/01/20 | Wednesday | 3 | 7 | 0 | 5 |
Ajlp 1 | 2010/02/01 | Monday | 5 | 12 | 0 | 11 |
Ajlp 1 | 2010/02/08 | Monday | 6 | 7 | 0 | 9 |
Ajlp 1 | 2010/02/11 | Thursday | 6 | 3 | 0 | 3 |
Ajlp 1 | 2010/02/17 | Wednesday | 7 | 6 | 0 | 47 |
Ajlp 1 | 2010/02/24 | Wednesday | 8 | 7 | 0 | 12 |
Ajlp 1 | 2010/03/03 | Wednesday | 9 | 7 | 0 | 85 |
<tbody>
</tbody>