Forum Discussion
sumifs errors
No column T carries the formula. Here is the Example
C E F H J L n
| 231-5026439-4 | 1 | MY | 6000 | 660 | $ 660.00 | 34.98 | 1.25000000 | 6000 | 0 | TRUE |
| 231-5026439-4 | 2 | PH | 9 | 453 | $ 453.00 | 0 | 2.25000000 | 9 | 0 | TRUE |
| 231-5026439-4 | 3 | CN | 6000 | 1176 | $ 1,176.00 | 323.4 | 3.25000000 | 6000 | 0 | TRUE |
| 231-5026439-4 | 4 | CN | 3 | 320 | $ 320.00 | 80 | 4.25000000 | 3 | 0 | TRUE |
| 231-5026439-4 | 5 | PH | 249 | 32783 | $ 32,783.00 | 0 | 5.25000000 | 249 | 0 | TRUE |
| 231-5026439-4 | 6 | CN | 2 | 124 | $ 124.00 | 31 | 6.25000000 | 2 | 0 | TRUE |
| 231-5026439-4 | 7 | MY | 200 | 80962 | $ 80,962.00 | 0 | 7.25000000 | 0 | -200 | FALSE |
| 231-5026439-4 | 8 | CN | 2070 | 5664 | $ 5,664.00 | 1416 | 8.25000000 | 0 | -2070 | FALSE |
| 231-5026439-4 | 9 | CN | 110 | 117 | $ 117.00 | 29.25 | 9.25000000 | 0 | -110 | FALSE |
| 231-5026439-4 | 10 | CN | 55 | 11 | $ 11.00 | 2.75 | 10.25000000 | 0 | -55 | FALSE |
| 231-5026439-4 | 11 | CN | 500 | 213 | $ 213.00 | 53.25 | 11.25000000 | 110 | -390 | FALSE |
| 231-5026439-4 | 12 | CN | 4640 | 5287 | $ 5,287.00 | 1321.75 | 12.25000000 | 55 | -4585 | FALSE |
I'm afraid that doesn't help. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar C:\Users\055885\OneDrive - Avnet\Excel
The task is to match TxnQty from sheet A with Qty sheet B which makes Delta a 0 and turns V to a True
Did this work/help
I'm afraid I cannot access your hard disk - please see my previous reply. You'll have to obtain a link in the browser.
HansVogelaar Here is the code:
=SUMIFS('[IP Data Expeditors Lines WIP.xlsx]Sheet1'!$G:$G,'[IP Data Expeditors Lines WIP.xlsx]Sheet1'!$C:$C,C111904,'[IP Data Expeditors Lines WIP.xlsx]Sheet1'!$D:$D,E111904)