Hi,
how can i VLOOKUP and SUM the below table? as you cna see we have multiple rows with the same item i need column B total for each item number.
Thanks
how can i VLOOKUP and SUM the below table? as you cna see we have multiple rows with the same item i need column B total for each item number.
A | B | |
1 | Item number | Total available |
2 | RM-000002 | 18.00 |
3 | RM-000002 | 95.00 |
4 | RM-000002 | 23.00 |
5 | RM-000002 | 95.00 |
6 | RM-000002 | 95.00 |
7 | RM-000002 | 35.00 |
8 | RM-000002 | 47.00 |
9 | RM-000003 | 0.00 |
10 | RM-000003 | 0.00 |
11 | RM-000003 | 9.00 |
12 | RM-000003 | 3.00 |
13 | RM-000004 | 30.00 |
14 | RM-000005 | 40.00 |
15 | RM-000006 | 33.00 |
16 | RM-000006 | 9.00 |
17 | RM-000006 | 21.00 |
18 | RM-000006 | 20.00 |
19 | RM-000007 | 15.00 |
20 | RM-000007 | 15.00 |
21 | RM-000008 | 3.00 |
22 | RM-000009 | 67.00 |
23 | RM-000010 | 4.00 |
24 | RM-000010 | 12.00 |
Thanks