Sum children if a condition is met in another column

Sylvia Elizabeth

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!

Paul Newcome

Try this...

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

Paul Newcome

Try this...

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

Sylvia Elizabeth

Hi Paul!

Thanks! that worked pretty good.

Thank you again :)

Paul 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.

Sylvia Elizabeth

Hi @Paul Newcome,

How can I adapt this formula if I want to include the sums of "Pagada" and "Pendiente de pago". I tried to use this formula by adding an OR but it didn't work.

=SUMIFS(OR(CHILDREN(); CHILDREN([Estatus factura]@row); "Pagada"; Pendiente pago))

Thank you!

Paul Newcome

It would look more like this...

=SUMIFS(CHILDREN(); CHILDREN([Estatus Factura]@row); OR(@cell = "Pagada"; @cell = "Pendiente pago"))

Sylvia Elizabeth

Thanks a lot Paul it worked very well!

Paul Newcome

Happy to help. 👍️

Nella Capra

How do I count children of Status Report Validations when more than one condition exists?

I want to count the total open Validations (children) when Done is not checked and Status only = "Identified Mismatch" or "Email Sent to PM" or "In Review"

Paul Newcome

@Nella Capra Try something like this...

=COUNTIFS(CHILDREN(Done@row, @cell <> 1, CHILDREN(Status@row), OR(@cell = "Identified Mismatch", @cell = "Email Sent to PM", @cell = "In Review"))

Nella Capra

@Paul Newcome - Thanks but it's not working. I always get this error:

Paul Newcome

My apologies. I missed a parenthesis...

=COUNTIFS(CHILDREN(Done@row), @cell <> 1, CHILDREN(Status@row), OR(@cell = "Identified Mismatch", @cell = "Email Sent to PM", @cell = "In Review"))