Can anyone help with this formula?

carak

I'm using in a sheet summary and it keeps returning #unparsable.

=SUMIFS([% Complete], [Task Type], "contract award") / SUMIFS([Duration], [Task Type], "contract award")

I'm trying to calculate the total % Complete as a percentage of the total duration for a specific task type.

Thanks

Cara

Find more posts tagged with

Accepted answers

bisaacs

Hey @carak,

If you're trying to have the formula search a whole column, you have to have the column range entered like this:

[% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration

Hope this helps!

All comments

bisaacs

Hey @carak,

If you're trying to have the formula search a whole column, you have to have the column range entered like this:

[% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration

Hope this helps!

carak

Thanks bisaacs, that worked :)

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.