Spreadsheet: 678245d1589797078-sumproduct-multiple-criteria-from-same-column-g-and-a
Sheet: Jan

 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020 | Year 2020
 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
 | 5721 | 5733 | 5731 | 5732 | 5730 | 5300 | 5310 | 5320 | 5330 | 5340 | 7303 | 5710 | 5720 | 5729 | HR
 | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan
Content | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Content Other Cost | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Content staff direct costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Content / Product Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 11.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing Advertising and promotion | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing Other marketing and advertising costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing Marketing / advertising staff direct costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing and Advertising | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0.68 | 31.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] finance and billing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] debt expense | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer Other customer operations costs | 0 | 0 | 0 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 2.11 | 0 | 0 | 0 | 72.11
[NAME] operations staff direct costs | 0 | 0 | 0 | 149.41491 | 0 | 0 | 0 | 0 | 0 | 0 | 130.66943 | 0 | 0 | 0 | 280.08434
[NAME] top-up cost | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer Operations | 0 | 0 | 0 | 219.41491 | 0 | 0 | 0 | 0 | 0 | 0 | 132.77943 | 0 | 0 | 0 | 352.19434
 | 0 | 6.61 | 227.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales Channel marketing support costs OPEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales Other channel operating costs OPEX | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40
Sales Logistics / Inventory OPEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales Sales and Distribution staff direct costs OPEX | 0 | 0 | 181.29966 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 181.29966
Sales Stock write-downs and movement in provisions [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales and  Distribution | 0 | 0 | 221.29966 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221.29966
 | 1.61 | 0 | 53.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G&A Other Staff direct costs | 105.09632 | 0 | 0 | 0 | 0 | 90.79769 | 76.2121 | 0 | 0 | 0 | 0 | 37.15 | 1153.83017 | 0 | 1463.08628
G&A Recruitment and training expenses | 439.879 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.701 | 4.4 | 0 | 460.98
G&A Total staff related expenses | 0 | 0 | 0 | 0 | 0 | 0 | -250 | 0 | 0 | 0 | 0 | 26.948 | 255.0952 | 0 | 32.04319999999996
G&A Professional fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G&A Rent and rates | 0 | 0 | 0 | 0 | 0 | 0 | 3412.59829 | -142.99199 | 44.196 | 0 | 0 | 0 | 0 | 0 | 3313.8023
G&A Other office expenses | 0 | 0 | 0 | 0 | 0 | 0 | -26.60044999999998 | 0.5165599999999999 | 5.065 | 0 | 0 | 0 | 0.002 | 0 | -21.01688999999998
G&A Other G&A / Other | -1.28 | 0 | 0 | 0 | 298.85257 | 0 | -22.78929000000001 | -4.99392 | 1.07722 | 0 | 0 | 58.333 | 610.52774 | -66.18503000000027 | 873.5422899999998
[NAME] service agreement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
G&A / Other | 543.69532 | 0 | 0 | 0 | 298.85257 | 90.79769 | 3189.42065 | -147.46935 | 50.33821999999999 | 0 | 0 | 139.132 | 2023.85511 | -66.18503000000027 | 6122.437179999999
 | 0 | 0 | 65.11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Retention Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Equipment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Logistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Commissions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Others (please specify) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Retention Staff Direct Costs - contract | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRC Contract Handset Receivable Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bad debt provision on handset receivables (net)
Net retention costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 59.51000000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC contract Revenue from handset sold with SIM (including connection fee) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC contract Cost of handsets sold with SIM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC contract Commissions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC contract Logistics / Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC contract Sales and Distribution staff direct costs - Acquisitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC Contract Handset Receivable Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bad debt provision on handset receivables (net)
Net customer acquisition costs - Contract | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC non contract Revenue from handset sold with SIM (including connection fee) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC non contract Cost of handsets sold with SIM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC non contract Commissions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAC non contract Logistics / Inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net customer acquisition costs - Non Contract | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net customer acquisition costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Own retail chain costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 3 | 343.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Own Retail | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Foreign exchange gains or (losses) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 543.69532 | 143.25 | 221.29966 | 219.41491 | 298.85257 | 90.79769 | 3189.42065 | -147.46935 | 50.33821999999999 | 0 | 132.77943 | 139.132 | 2023.85511 | -66.18503000000027 | 6839.181179999999