Spreadsheet: 752878d1635051377-sumifs-of-different-sheets-on-the-basis-of-header-24102021-sample-format-for-excel-forum
Sheet: May 2021

Business Month | PRODUCT_CODE | POLICY_START_DATE | POLICY_END_DATE | MOTOR_OD_PREMIUM_AMOUNT | BASIC_PREMIUM_AMOUNT | PERC_COMMISION | OD Commission | TOTAL_ ACTUAL_COMMISSION
May 2021 | 1001 | 2021-03-23 00:00:00 | 2026-03-22 00:00:00 | 0 | 4631 | 10 | 463.1 | 463.1
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 2510 | 11.5 | 288.65 | 288.65
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 3409 | 11.5 | 392.04 | 392.04
May 2021 | 1015 | 2021-04-28 00:00:00 | 2031-04-27 00:00:00 | 0 | 4800 | 16.5 | 792 | 792
May 2021 | 1001 | 2021-03-22 00:00:00 | 2022-03-21 00:00:00 | 0 | 3344 | 10 | 334.4 | 334.4
May 2021 | 1001 | 2021-03-23 00:00:00 | 2026-03-22 00:00:00 | 0 | 3357 | 10 | 335.7 | 335.7
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 6250 | 11.5 | 718.75 | 718.75
May 2021 | 1016 | 2021-05-31 00:00:00 | 2022-05-30 00:00:00 | 0 | 4950 | 11.5 | 569.25 | 569.25
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 10322 | 11.5 | 1187.03 | 1187.03
May 2021 | 1016 | 2021-04-30 00:00:00 | 2022-04-29 00:00:00 | 0 | 12105 | 16.5 | 1997.33 | 1997.33
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 810 | 16.5 | 133.65 | 133.65
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 4733 | 11.5 | 544.3 | 544.3
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 6291 | 11.5 | 723.47 | 723.47
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 687 | 16.5 | 113.36 | 113.36
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 2000 | 16.5 | 330 | 330
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 5622 | 11.5 | 646.53 | 646.53
May 2021 | 1016 | 2021-05-17 00:00:00 | 2022-05-16 00:00:00 | 0 | 435 | 11.5 | 50.03 | 50.03
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 2691 | 11.5 | 309.47 | 309.47
May 2021 | 1001 | 2021-03-22 00:00:00 | 2031-03-21 00:00:00 | 0 | 8663 | 10 | 866.3 | 866.3
May 2021 | 1016 | 2021-05-31 00:00:00 | 2022-05-30 00:00:00 | 0 | 3583 | 11.5 | 412.05 | 412.05
May 2021 | 1016 | 2021-04-30 00:00:00 | 2022-04-29 00:00:00 | 0 | 7410 | 16.5 | 1222.65 | 1222.65
May 2021 | 1015 | 2021-04-28 00:00:00 | 2022-04-27 00:00:00 | 0 | 1675 | 16.5 | 276.38 | 276.38
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 9295 | 11.5 | 1068.93 | 1068.93
May 2021 | 1001 | 2021-03-23 00:00:00 | 2022-03-22 00:00:00 | 0 | 336 | 10 | 33.6 | 33.6
May 2021 | 1001 | 2021-03-23 00:00:00 | 2022-03-22 00:00:00 | 0 | 2869 | 10 | 286.9 | 286.9
May 2021 | 1001 | 2021-03-23 00:00:00 | 2022-03-22 00:00:00 | 0 | 2013 | 10 | 201.3 | 201.3
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 7691 | 16.5 | 1269.02 | 1269.02
May 2021 | 1016 | 2021-05-28 00:00:00 | 2022-05-27 00:00:00 | 0 | 3852 | 11.5 | 442.98 | 442.98
May 2021 | 1001 | 2021-03-22 00:00:00 | 2031-03-21 00:00:00 | 0 | 2301 | 10 | 230.1 | 230.1
May 2021 | 1001 | 2021-03-22 00:00:00 | 2041-03-21 00:00:00 | 0 | 11138 | 10 | 1113.8 | 1113.8
May 2021 | 1016 | 2021-05-17 00:00:00 | 2022-05-16 00:00:00 | 0 | 12228 | 11.5 | 1406.22 | 1406.22
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 9958 | 11.5 | 1145.17 | 1145.17
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 18577 | 11.5 | 2136.36 | 2136.36
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 2000 | 16.5 | 330 | 330
May 2021 | 1015 | 2021-04-28 00:00:00 | 2026-04-27 00:00:00 | 0 | 6500 | 16.5 | 1072.5 | 1072.5
May 2021 | 1016 | 2021-05-17 00:00:00 | 2022-05-16 00:00:00 | 0 | 3485 | 11.5 | 400.78 | 400.78
May 2021 | 1001 | 2021-03-22 00:00:00 | 2031-03-21 00:00:00 | 0 | 2104 | 10 | 210.4 | 210.4
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 20202 | 11.5 | 2323.23 | 2323.23
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 4892 | 11.5 | 562.58 | 562.58
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 1087 | 11.5 | 125.01 | 125.01
May 2021 | 1015 | 2021-04-28 00:00:00 | 2031-04-27 00:00:00 | 0 | 9600 | 16.5 | 1584 | 1584
May 2021 | 1001 | 2021-03-23 00:00:00 | 2022-03-22 00:00:00 | 0 | 403 | 10 | 40.3 | 40.3
May 2021 | 1001 | 2021-03-22 00:00:00 | 2026-03-21 00:00:00 | 0 | 2685 | 10 | 268.5 | 268.5
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 2697 | 11.5 | 310.16 | 310.16
May 2021 | 1015 | 2021-04-27 00:00:00 | 2031-04-26 00:00:00 | 0 | 8000 | 16.5 | 1320 | 1320
May 2021 | 1001 | 2021-03-23 00:00:00 | 2026-03-22 00:00:00 | 0 | 8250 | 10 | 825 | 825
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 1705 | 16.5 | 281.33 | 281.33
May 2021 | 4002 | 2021-05-31 00:00:00 | 2022-05-30 00:00:00 | 0 | 254 | 10 | 25.4 | 25.4
May 2021 | 1015 | 2021-05-17 00:00:00 | 2026-05-16 00:00:00 | 0 | 5409 | 16.5 | 892.49 | 892.49
May 2021 | 1016 | 2021-05-28 00:00:00 | 2022-05-27 00:00:00 | 0 | 7468 | 11.5 | 858.82 | 858.82
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 3088 | 11.5 | 355.12 | 355.12
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 781 | 16.5 | 128.87 | 128.87
May 2021 | 1001 | 2021-03-23 00:00:00 | 2022-03-22 00:00:00 | 0 | 4244 | 10 | 424.4 | 424.4
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 2368 | 11.5 | 272.32 | 272.32
May 2021 | 1016 | 2021-04-28 00:00:00 | 2022-04-27 00:00:00 | 0 | 8000 | 16.5 | 1320 | 1320
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 781 | 16.5 | 128.87 | 128.87
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 9225 | 11.5 | 1060.88 | 1060.88
May 2021 | 1015 | 2021-04-28 00:00:00 | 2026-04-27 00:00:00 | 0 | 7350 | 16.5 | 1212.75 | 1212.75
May 2021 | 1016 | 2021-04-29 00:00:00 | 2022-04-28 00:00:00 | 0 | 15000 | 11.5 | 1725 | 1725
May 2021 | 1015 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 810 | 16.5 | 133.65 | 133.65
May 2021 | 1016 | 2021-05-27 00:00:00 | 2022-05-26 00:00:00 | 0 | 3303 | 11.5 | 379.85 | 379.85