commonproblems
New Member
- Joined
- Apr 25, 2018
- Messages
- 7
Hi everyone,
i need help summing the population of birds whose age is greater than 60 weeks, on a row by row basis.
The data set is below:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2000[/TD]
[TD]76[/TD]
[TD]110[/TD]
[TD]100[/TD]
[TD]2000[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]2000[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1990[/TD]
[TD]77[/TD]
[TD]120[/TD]
[TD]100[/TD]
[TD]1990[/TD]
[TD]62[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]1990[/TD]
[TD]51[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1980[/TD]
[TD]78[/TD]
[TD]130[/TD]
[TD]100[/TD]
[TD]1980[/TD]
[TD]63[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]1980[/TD]
[TD]51[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
So the answer for Row 1 is 4,000. this is a simplistic data set. The actual data set is very long.
thank you for you help!
[TABLE="width: 1527"]
<colgroup><col><col><col span="15"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i need help summing the population of birds whose age is greater than 60 weeks, on a row by row basis.
The data set is below:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[TD]Population[/TD]
[TD]Age[/TD]
[TD]Eggs[/TD]
[TD]Feed[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2000[/TD]
[TD]76[/TD]
[TD]110[/TD]
[TD]100[/TD]
[TD]2000[/TD]
[TD]61[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]2000[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1990[/TD]
[TD]77[/TD]
[TD]120[/TD]
[TD]100[/TD]
[TD]1990[/TD]
[TD]62[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]1990[/TD]
[TD]51[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1980[/TD]
[TD]78[/TD]
[TD]130[/TD]
[TD]100[/TD]
[TD]1980[/TD]
[TD]63[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]1980[/TD]
[TD]51[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
So the answer for Row 1 is 4,000. this is a simplistic data set. The actual data set is very long.
thank you for you help!
[TABLE="width: 1527"]
<colgroup><col><col><col span="15"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]