Forum Discussion

Copper Contributor

May 10, 2022

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...

excel

Formulas and Functions

HansVogelaar

MVP

May 10, 2022

Mrteeser

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.

Mrteeser

Copper Contributor

May 10, 2022

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

HansVogelaar
MVP
May 10, 2022
Mrteeser

I'm afraid I cannot access your hard disk - please see my previous reply. You'll have to obtain a link in the browser.
- Mrteeser
  Copper Contributor
  May 16, 2022
  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)
  - HansVogelaar
    MVP
    May 16, 2022
    Mrteeser
    
    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.