nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi, I have two tables, in two seperate worksheets. I will refer to them as table and table 2.
In table one I have a reference number in col A and a value (%) which i would like to show in col B.
Table 1
<tbody>
</tbody>
In Table 2 I have a unique reference number in col A, in col B I have a number that will match that of one of the references in col A of table 1. In col C I have a another % progress value.
Table 2
<tbody>
</tbody>
From the two tables in seperate worksheets i need to calculate the total % using the reference number. So as an example, table one, when the correct formula is applied will look like the below:
<tbody>
</tbody>
So, Table 1 needs to look at table 2, it will look to see if any reference in col B of table 2 are the same as the reference in table 1. If it is it will add up the sum of all those that match and return a result showing the sum of all percentages matching the reference as in example above.
I hope that makes some kind of sense and I thank you in advance for your support.
In table one I have a reference number in col A and a value (%) which i would like to show in col B.
Table 1
Reference | % Progress |
1 | |
2 | |
3 | |
4 |
<tbody>
</tbody>
In Table 2 I have a unique reference number in col A, in col B I have a number that will match that of one of the references in col A of table 1. In col C I have a another % progress value.
Table 2
Unique Reference | Reference (to Table 1) | % Progress |
10 | 2 | 15% |
11 | 2 | 30% |
12 | 1 | 10% |
13 | 2 | 5% |
<tbody>
</tbody>
From the two tables in seperate worksheets i need to calculate the total % using the reference number. So as an example, table one, when the correct formula is applied will look like the below:
Reference | % Progress |
1 | 10% |
2 | 50% |
3 | 0% |
4 | 0% |
<tbody>
</tbody>
So, Table 1 needs to look at table 2, it will look to see if any reference in col B of table 2 are the same as the reference in table 1. If it is it will add up the sum of all those that match and return a result showing the sum of all percentages matching the reference as in example above.
I hope that makes some kind of sense and I thank you in advance for your support.