I am tring to sum the values in Col B where the ageing is > 40 days, but my SUMIFS FORmula is giving me the incorrect answer. It should be 3666.108
It would be appreciated if someone can check and amend my formula
It would be appreciated if someone can check and amend my formula
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Ageing > 40 Days | R326.28 | ||||
2 | ||||||
3 | Ageing | Value | % of Total | |||
4 | 1572.997 | 8.14% | ||||
5 | 10-15 | 3745.451 | 19.39% | |||
6 | 15-20 | 2482.914 | 12.85% | |||
7 | 20-25 | 2703.909 | 14.00% | |||
8 | 25-30 | 2089.743 | 10.82% | |||
9 | 30-35 | 2298.29 | 11.90% | |||
10 | 35-40 | 434.3407 | 2.25% | |||
11 | 40-45 | 326.2813 | 1.69% | |||
12 | 45-50 | 384.9833 | 1.99% | |||
13 | 50-55 | -7.37867 | -0.04% | |||
14 | 55-60 | 14.66667 | 0.08% | |||
15 | >60 | 3273.837 | 16.95% | |||
16 | Grand Total | 19320.03 | 100.00% | |||
17 | ||||||
Sheet1 |