Sum children if a condition is met in another column

Sum children if a condition is met in another column

Hi,

Im trying to count the children of column [Estimado Importe Total] but I just want to count the values if the condition in column [Estatus Factura] says "Pagada", if not I just want to skip that row and count the rest of the conditions that are met.

Here is my example:



Hope someone can help me.


Thankyou!

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try this...

    =SUMIFS(CHILDREN(), CHILDREN([Estatus Factura]@row), "Pagada")

  • Hi Paul!

    Thanks! that worked pretty good.

    Thank you again :)

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! 👍️


    Please don't forget to mark the most appropriate response(s) as "helpful". This will help others searching for a similar solution possibly find one here.

Sign In or Register to comment.