Forum Discussion
sumifs errors
I am using the following formula to match data from two different spreadsheets. This works for the individual row but I need to do around a thousand rows. When I hit the + to copy down to the remai...
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)
Once again...
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.