SUMIF formula error

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,

Find more posts tagged with

Accepted answers

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())

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.