Spreadsheet: 775396d1649081190-sum-and-text-if-specific-keywords-sum-if-text
Sheet: Sheet1

Year | VALUE | Text | Category |  |  | Category | Rule | Value 2020 | Value 2021 | Sum all years
2020 | 55 | CIC # AP09_excel IE/DE_BILL GATES # WIP- Simon Adjustment EUR |  |  |  | A | If [NAME]
2021 | 357.5 | CIC # AP09_excel IE/DE_WAREEN BUFFET # WIP- Simon Adjustment EUR |  |  |  | B | If Microsoft
2020 | 302.5 | CIC # AP10_excel IE/DE_WAREEN BUFFET # WIP- Simon Adjustment EUR |  |  |  | C | If FY20GSL / FY21GSL
2021 | 2420 | HIT/SIT # [PHONE] # Microsoft SOLUTIONS AB # [NAME] for project excel WFH
2020 | 980 | HIT/SIT # [NAME] # Microsoft SOLUTIONS AB # [NAME] WREQ2110201145 for project excel- Northern Ireland – is no longer part of EU – should not be subject to customs
2021 | 3080 | HIT/SIT # [NAME] excel [NAME] AP09-21 # MU_S5501_MBEMHO_DV01 AP10-21 Adjustment EUR # Adjustment EUR
2020 | 1760 | HIT/SIT # [NAME] excel [NAME] AP09-21 # MU_S5501_MBEMHO_DV01 AP10-21 Adjustment EUR # Adjustment EUR
2021 | 2200 | HIT/SIT # [NAME] excel IE EMEA AP09-21 # MU_S5501_MBEMHO_DV01 AP10-21 Adjustment EUR # Adjustment EUR
2020 | 2777.78 | HIT/SIT # RCT Tool Jan-22 [NAME]-22 # [NAME]-22 Adjustment EUR # WIP to BS - Controlling Adjustment EUR
2021 | 1852.5 | LIT # AP07_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP- Simon Adjustment EUR
2020 | 5985 | LIT # AP08_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP- Simon Adjustment EUR
2021 | 6768.75 | LIT # AP09_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP- Simon Adjustment EUR
2020 | 1282.5 | LIT # AP10_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP Correction AP10_2021 Adjustment EUR # Project Accuray & excel Reclass - Harini Adjustment EUR
2021 | 1282.5 | LIT # AP10_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP- Simon Adjustment EUR # Project MU reclas [NAME] Adjustment EUR
2020 | -1282.5 | LIT # AP10_excel IE/DE_IT PM CHARLIZE THERON / PM4 # WIP- Simon Adjustment EUR # Project MU reclas [NAME] Adjustment EUR
2021 | 5486.25 | LIT # AP11 - excel - CHARLIZE THERON # WIP Adjustment EUR
2020 | -5486.25 | LIT # AP11 - excel - CHARLIZE THERON # WIP- Simon Adjustment EUR
2021 | 5486.25 | LIT # AP11 # excel # CHARLIZE THERON # WIP- Simon Adjustment EUR
2020 | 1541.26 | LIT #excel Global IT Dec-21 cost - UKI (recharged to DBEXNV) AP01-22 # [NAME]-22 Adjustment EUR # WIP to BS - Controlling Adjustment EUR
2021 | 44600.12 | OTH # excel Global IT - DE work in progress reference "AIB 2000048" (recharged to DBEXNV) AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2020 | 27619.94 | OTH # excel Global IT - UKI (recharged to DBEXNV) AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2021 | 10645.89 | OTH # excel Global IT Nov-21 cost - DE work in progress reference "AIB 2000048" (recharged to DBEXNV) AP12-21 # MU_S5501_MBEMHO_DV01 AP12-21 Adjustment EUR
2020 | 6592.78 | OTH # excel Global IT Nov-21 cost - UKI (recharged to DBEXNV) AP12-21 # MU_S5501_MBEMHO_DV01 AP12-21 Adjustment EUR
2021 | 10247.69 | OTH # excel Global PIM - DE work in progress reference "AIB 2000048" (recharged to DBEXNV) AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2020 | 6346.18 | OTH # excel Global PIM - UKI (recharged to DBEXNV) AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2021 | 7395.24 | OTH # excel Global PIM Nov-21 cost - DE work in progress reference "AIB 2000048" (recharged to DBEXNV) AP12-21 # MU_S5501_MBEMHO_DV01 AP12-21 Adjustment EUR
2020 | 4579.73 | OTH # excel Global PIM Nov-21 cost - UKI (recharged to DBEXNV) AP12-21 # MU_S5501_MBEMHO_DV01 AP12-21 Adjustment EUR
2021 | 731.4 | OTH # excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP05-21 # MU_S5501_MBEMHO_DV01 AP06-21 Adjustment EUR
2020 | 6358.08 | OTH # excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP05-21 # MU_S5501_MBEMHO_DV01 AP07-21 Adjustment EUR
2021 | 10018.11 | OTH # excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP05-21 # MU_S5501_MBEMHO_DV01 AP08-21 Adjustment EUR
2020 | 7413.02 | OTH # excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP05-21 # MU_S5501_MBEMHO_DV01 AP09-21 Adjustment EUR
2021 | 61555.31 | OTH # excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP10-21 # MU_S5501_MBEMHO_DV01 AP10-21 Adjustment EUR
2020 | 452.94 | OTH # excel Global SL Implementation UKI AP05-21 # MU_S5501_MBEMHO_DV01 AP06-21 Adjustment EUR
2021 | 3937.43 | OTH # excel Global SL Implementation UKI AP05-21 # MU_S5501_MBEMHO_DV01 AP07-21 Adjustment EUR
2020 | 6204.01 | OTH # excel Global SL Implementation UKI AP05-21 # MU_S5501_MBEMHO_DV01 AP08-21 Adjustment EUR
2021 | 4590.73 | OTH # excel Global SL Implementation UKI AP05-21 # MU_S5501_MBEMHO_DV01 AP09-21 Adjustment EUR
2020 | 38119.95 | OTH # excel Global SL Implementation UKI AP10-21 # MU_S5501_MBEMHO_DV01 AP10-21 Adjustment EUR
2021 | -153623 | OTH # OTH # [PHONE] # MDE310 DHL SOLUTIONS GMBH # BE Project management # WIP to BS - Controlling Adjustment EUR
2020 | -86075.92 | OTH # Reverse excel Global SL Implementation Germany work in progress reference "AIB 2000048" (recharged to DBEXNV) AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2021 | -53305.06 | OTH # Reverse excel Global SL Implementation UKI AP11-21 # MU_S5501_MBEMHO_DV01 AP11-21 Adjustment EUR
2020 | 395 | PIM # AP05_excel IE/DE_MICHELLE OBAMA # WIP Adjustment EUR
2021 | 1975 | PIM # AP06_excel IE/DE_MICHELLE OBAMA # WIP Adjustment EUR
2020 | 790 | PIM # AP07_excel IE/DE_MICHELLE OBAMA # WIP- Simon Adjustment EUR
2021 | 1086.25 | PIM # AP09_IBM UK/IE_MICHELLE OBAMA # WIP- Simon Adjustment EUR
2020 | 30 | OTH # TO EMEA CD AP02-21  -FY21GSL1190 - # MU_S5528_MBEMHO_DV_AP02-21_11 - Adj Adjustment EUR # Adjustment EUR
2021 | 327.12 | OTH # TO EMEA CD AP03-21  -FY20GSL1190 - Philisp Blueroom Poland # MU_S5528_MBEMHO_DV_AP03-21_11 - Adj Adjustment EUR # Adjustment EUR