Mingalator
Board Regular
- Joined
- Oct 28, 2008
- Messages
- 53
Hi all,
I have a problem trying to sum a range, should be quite simple but can't wrap my head around it.
So in the table below: I would like to sum all the unique values within each branch, so for example for branch 123456 the answer I am looking for would be 2 and for branch 234567 I would want an answer of 1.8
I have tried various iterations of sumproduct, sumif with nesting countif and frequency but don't seem to have come close to answer, so any help would be appreciated. Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Branch[/TD]
[TD]ID[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]876[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]876[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]765[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]765[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]654[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]654[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
I have a problem trying to sum a range, should be quite simple but can't wrap my head around it.
So in the table below: I would like to sum all the unique values within each branch, so for example for branch 123456 the answer I am looking for would be 2 and for branch 234567 I would want an answer of 1.8
I have tried various iterations of sumproduct, sumif with nesting countif and frequency but don't seem to have come close to answer, so any help would be appreciated. Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Branch[/TD]
[TD]ID[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]987[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]876[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123456[/TD]
[TD]876[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]765[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]765[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]654[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567[/TD]
[TD]654[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]