|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Excel =SUMIF(RANGE) formula not working when Imported.

Be om demo

If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "TD", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "TD."

Is there a workaround so that this =SUMIF(Range) formula will work when using the "Import" functionality? I have suggested using Wdesk Sync function but with doing so we would lose the data trail we would like to maintain.

cc: Raymond Charouneau

0

Kommentarer

2 kommentarer

Dato Stemmer
  • Liz Habel

    Hi Chuck,

    Thank you for your question and your patience while we looked into this. Can you elaborate on the issues you're experiencing when you are importing the SUMIF formula? I attempted importing an xlsx file using an example like the one you provided and found it to be successful. Knowing a little bit more about your situation will help me find the right guidance for you. 

    Looking forward to hearing from you! 

     

    0
  • Chuck
    • Redigert

    Liz Habel

    From my experience, the issue arises when I use a SUMIFS function in excel with a range of criteria

    e.g =SUM(SUMIFS('E&R Lob Data'!$E:$E,'E&R Lob Data'!$A:$A,$Q506,'E&R Lob Data'!$B:$B,C$501,'E&R Lob Data'!$D:$D,$R506:$X506))

    Without the range, the function works okay in Wdesk. I think, prior to excel 2016, the function would have need an array style setup so maybe this is the issue

    0

Logg på for å legge inn en kommentar.