|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Sumproduct formula with multiple criteria

Besvarat
Begär demo

Hi,

i uploaded the files where i use this formula: =IF(B4=0,0,SUMPRODUCT(--('2017 YTD'!$B$133:$B$1000">="&B1),--('2017 YTD'!$B$133:$B$1000"<="&B2),'2017 YTD'!$E$133:$E$1000)/B4)

However, it doesn't work. Does anyone know if this formula supported in the Workiva?

4

Kommentarer

39 kommentarer

Datum Röster
  • Permanently deleted user

    We really need this functionality operational.
    Thank you.

    0
  • Danilo Sato

    Hi Mike Davis, do you have an update on this request? It was planned for 2024, but it seems not working yet.

    Thanks!

    1
  • Joshua Wallis

    Looking forward to this as well! 

    2
  • Jonathan Zabel

    Hi Mike Davis, do you have an update on this request? 

    2
  • Mike Davis

    Hi Jonathan!

    While SUMPRODUCT is supported, the use of ARRAY within that is not yet available still but does remain on the roadmap to be added. I don't have a timeline yet for this but will continue to keep followers updated. I am happy to add you there as well.

    -1
  • Michael McDaniel
    • Redigerad

    Please add me to the update.

    1
  • Brooke Mortvedt

    Hi Michael McDaniel,

    Thanks for chiming in here on your need for this feature. I've added you to the request.

    Thanks again, and have a great day!

    -1
  • Eric Scott

    Please add me too.  It looks like there's a lot of users in line behind Yulia Oleynik requesting this feature update.

    1
  • Brooke Mortvedt

    Hi Eric Scott Thanks for commenting, I have you added to this request!

    0

Du måste logga in om du vill lämna en kommentar.