SUMIF formula error

Corentin Dal Farra

Hello everyone,

I think I have a simple question but I did not find the answer yet :

I have a sheet with this data :

I would like to put a formula that sum the amount of money in "Dépenses liées à la tâche" column, only if the status in "Statut" column is "terminé".

I get an error and I can't find what to do. Is it because my formula is on the same column that the data I need to sum ?

Thank you for your help,

Have a nice day,

sravya.gupta127326

Hello,

You need to change your 1st range to be children too - so, in the formula - make it

=sumif(children(Statut@row;"termine";children())

sravya.gupta127326

Hello,

You need to change your 1st range to be children too - so, in the formula - make it

=sumif(children(Statut@row;"termine";children())

Corentin Dal Farra

Hello @sravya.gupta127326

It works well with this formula :

Thank you very much !

Corentin