|
Os tipos de arquivos clássicos não estarão mais disponíveis para uso a partir de janeiro de 2021. Você pode fazer a transição de seus arquivos clássicos ou baixar um PDF. Saber mais

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

Solicitar demonstração

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

Comentários

2 comentários

Data Votos
  • 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
    • Editado

    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

Por favor, entrar para comentar.