|
Los tipos de archivo clásicos dejarán de estar disponibles a partir de enero de 2021. Puedes migrar tus archivos clásicos o descargar un PDF. Más información

Sumproduct formula with multiple criteria

Respondida
Solicitar demostración

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

Comentarios

39 comentarios

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

    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

Iniciar sesión para dejar un comentario.