askall1000
Board Regular
- Joined
- Jan 3, 2019
- Messages
- 58
- Office Version
- 2016
- Platform
- Windows
Thank you in advance. I want to find the percentage of completed reconciliation in F2 cell, this is only part of whole data, my table goes 100, 102, 120 etc (not serial). There are also sub accounts; I am trying to do when I enter account code to F1, F2 will show me how much is completed base on reference column with Ref* and main account e.g 102.
sil01.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Account Code | 100 | ||||||
2 | Percentage of complete | |||||||
3 | Account Code | Total | Reference | |||||
4 | 100 | 92.789,69 | ||||||
5 | 100 01 | 55.800,00 | ||||||
6 | 100 01 001 | 55.800,00 | ||||||
7 | 100 02 | 36.989,69 | ||||||
8 | 100 02 001 | 4.222,70 | ||||||
9 | 100 02 002 | 32.766,99 | ||||||
10 | 102 | 4.046.887,96 | ||||||
11 | 102 01 | 90.311,81 | ||||||
12 | 102 01 002 | 43.606,48 | RefB003 | |||||
13 | 102 01 003 | 7.503,73 | RefB002 | |||||
14 | 102 01 005 | 28,44 | RefB004 | |||||
15 | 102 01 006 | 6,35 | x | |||||
16 | 102 01 007 | 39.166,81 | RefB001 | |||||
17 | 102 02 | 0,00 | ||||||
18 | 102 02 001 | 0,00 | ||||||
19 | 102 02 002 | 0,00 | ||||||
20 | 102 03 | 3.956.576,15 | ||||||
21 | 102 03 001 | 2.885.970,19 | RefB003 | |||||
22 | 102 03 002 | 532.722,97 | RefB003 | |||||
23 | 102 03 003 | 537.882,99 | RefB003 | |||||
Sheet1 |