Spreadsheet: 785597d1656509351-problem-with-sumifs-formula-sample
Sheet: 1

 | Description | Rates | Apr'22 |  |  |  |  |  |  | May'22 |  |  |  |  |  |  | Jun'22
 |  |  | Apr'22 | Apr'22 | Apr'22 | Apr'22 | Apr'22 | Apr'22 |  | May'22 | May'22 | May'22 | May'22 | May'22 | May'22 |  | Jun'22 | Jun'22 | Jun'22 | Jun'22 | Jun'22 | Jun'22
 |  |  | T1 | N1 | O1 | T2 | T3 | T4 |  | T1 | N1 | O1 | T2 | T3 | T4 |  | T1 | N1 | O1 | T2 | T3 | T4
 | Sree Prakiruti Foods
 |  | 418 | 20 |  |  |  |  | 15 |  |  |  | 33 |  | 10 | 10 |  |  |  |  |  | 5 | 5
e |  | 0.85 |  | 3000 | 2400 | 3200 |  | 6000 |  | 5000 | 3000 | 16000 | 1000 | 1000 | 1000 |  |  |  |  |  | 3000 | 5000
 |  | 3.42 | 300 |  |  |  |  | 500 |  |  |  | 600 |  |  |  |  |  |  |  |  | 500 | 1000
 |  | 1.62 | 200 | 200 |  | 800 |  | 500 |  |  | 300 | 700 |  |  |  |  |  |  |  |  | 500 | 500
 |  | 1.62 | 500 |  |  | 100 |  | 500 |  |  | 50 | 1200 | 500
 |  | 1.62 | 500 | 100 |  | 300 |  | 500 |  |  | 300 | 1700 |  |  | 500 |  |  |  |  |  | 500 | 500
 |  | 1.62 |  | 100 |  | 300 |  | 500 |  |  | 200 | 700 |  |  | 500 |  |  |  |  |  | 500 | 500
 |  | 4.1 | 240 |  |  | 100 |  | 1000 |  |  | 100 | 2800 | 200 | 500 | 500 |  |  |  |  |  | 1000 | 1000
 |  | 4.1 | 240 |  | 1500 |  |  | 1000 |  |  | 1200 | 2800 | 100 | 500 | 500 |  |  |  |  |  | 1500 | 1500
 |  | 80 |  |  |  | 3 |  | 3 |  |  | 5 | 22 | 6 |  |  |  |  |  |  |  | 5 | 7
 |  | 715 | 3 | 3 | 4 |  |  | 3 |  |  | 3 | 4 | 2 | 2 | 3
 |  | 100 | 4 | 2 | 4 |  |  | 3 |  |  | 2 | 4 | 2 | 3 | 3
 |  | 45 |  |  |  |  |  |  |  |  | 653 | 1716 | 420
 |  | Cost | Apr'22 |  |  |  |  |  |  | Apr'22 |  |  |  |  |  |  | Apr'22
 |  |  | Tidel-5th | NMR | OMR | Ticel | TPTY | TPTY |  | Tidel-5th | NMR | OMR | Ticel | TPTY | TPTY |  | Tidel-5th | NMR | OMR | Ticel | TPTY | TPTY
 |  | 418 | 8360 | 0 | 0 | 0 | 0 | 6270 |  | 0 | 0 | 13794 | 0 | 4180 | 4180 |  | 0 | 0 | 0 | 0 | 2090 | 2090
 |  | 1.62 | 810 | 0 | 0 | 162 | 0 | 810 |  | 0 | 81 | 1944 | 810 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1.62 | 810 | 162 | 0 | 486.0000000000001 | 0 | 810 |  | 0 | 486.0000000000001 | 2754 | 0 | 0 | 810 |  | 0 | 0 | 0 | 0 | 810 | 810
 |  | 1.62 | 324 | 324 | 0 | 1296 | 0 | 810 |  | 0 | 486.0000000000001 | 1134 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 810 | 810
 |  | 1.62 | 0 | 162 | 0 | 486.0000000000001 | 0 | 810 |  | 0 | 324 | 1134 | 0 | 0 | 810 |  | 0 | 0 | 0 | 0 | 810 | 810
 |  | 0.85 | 0 | 2550 | 2040 | 2720 | 0 | 5100 |  | 4250 | 2550 | 13600 | 850 | 850 | 850 |  | 0 | 0 | 0 | 0 | 2550 | 4250
 |  | 3.42 | 1026 | 0 | 0 | 0 | 0 | 1710 |  | 0 | 0 | 2052 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1710 | 3420
 |  | 4.1 | 983.9999999999999 | 0 | 0 | 409.9999999999999 | 0 | 4100 |  | 0 | 409.9999999999999 | 11480 | 819.9999999999999 | 2050 | 2050 |  | 0 | 0 | 0 | 0 | 4100 | 4100
 |  | 4.1 | 983.9999999999999 | 0 | 6149.999999999999 | 0 | 0 | 4100 |  | 0 | 4920 | 11480 | 409.9999999999999 | 2050 | 2050 |  | 0 | 0 | 0 | 0 | 6149.999999999999 | 6149.999999999999
 |  | 80 | 0 | 0 | 0 | 240 | 0 | 240 |  | 0 | 400 | 1760 | 480 | 0 | 0 |  | 0 | 0 | 0 | 0 | 400 | 560
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 715 | 2145 | 2145 | 2860 | 0 | 0 | 2145 |  | 0 | 2145 | 2860 | 1430 | 1430 | 2145 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 100 | 400 | 200 | 400 | 0 | 0 | 300 |  | 0 | 200 | 400 | 200 | 300 | 300 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 15843 | 5543 | 11450 | 5800 | 0 | 27205 |  | 4250 | 12002 | 64392 | 5000 | 10860 | 13195 |  | 0 | 0 | 0 | 0 | 19430 | 23000
 |  |  | 689.42 | 291 | 897.9 | 187.25 | 0 | 1387.65 |  | 106.25 | 824.925 | 3428.5 | 342.1 | 650.4499999999999 | 755.3 |  | 0 | 0 | 0 | 0 | 1178 | 1277.65
 |  |  | 689.42 | 291 | 897.9 | 187.25 | 0 | 1387.65 |  | 106.25 | 824.925 | 3428.5 | 342.1 | 650.4499999999999 | 755.3 |  | 0 | 0 | 0 | 0 | 1178 | 1277.65
 | Total |  | 17221.84 | 6125 | 13245.8 | 6174.5 | 0 | 29980.3 |  | 4462.5 | 13651.85 | 71249 | 5684.200000000001 | 12160.9 | 14705.6 |  | 0 | 0 | 0 | 0 | 21786 | 25555.3