AVERAGEIF or AVG ??????Why is this not working and how do i get it to work

So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please help

the formulas i though should work in the purple #invalid data type is =AVERAGEIF(CHILDREN(Completed91), ="Completed", CHILDREN())

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Wrap your formula in the red row in an IFERROR statement. That should remove the error and allow the other formulas to run.

=IFERROR(original_formula, "")

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.