|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

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

Demande de démonstration

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

Commentaires

2 commentaires

Date Votes
  • 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
    • Modifié

    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

Vous devez vous connecter pour laisser un commentaire.