WalterWhite
New Member
- Joined
- Feb 6, 2019
- Messages
- 3
Hi everyone there is my problem; i have 2 different excel file. First one is BW, second one BI. I was using SUMIF formula for my second excel. it was fine until repeating numbers came up. As you can see its summing for each repeating numbers and i don't want that. I want the average of the sum. For example in my second table would be 410 for each number is ideal for me. How can i do that ?
<tbody>
</tbody>
<tbody>
</tbody>
B | W |
6309641 | 320 |
6309641 | 350 |
6309641 | 60 |
6309641 | 90 |
6258924 | 100 |
6258924 | 120 |
<tbody>
</tbody>
B | I |
6309641 | 820 |
6309641 | 820 |
6258924 | 220 |
<tbody>
</tbody>