|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Sumproduct formula with multiple criteria

Answered
Request 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

Comments

39 comments

Date Votes
  • 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
    • Edited

    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

Please sign in to leave a comment.