Formula Help

I am for some reason having an issue getting function to calculate correctly. I need to pull the count for just active projects in one column but it is calculating all of them. There should only be 143. Can anyone help with this?

=SUMIF([Project Phase]:[Project Phase], "Active")

=COUNTIF([Project Phase]:[Project Phase], "Active")

=COUNTIFS([Project Phase]:[Project Phase], "Active")

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try a COUNTIFS instead.

Minni

I have tried it and it is not giving m the correct number. I have tried SUM, SUMIF, SUMIFS, COUNT, COUNTIF, and COUNTIFS and it is just not working

Hollie Green

what count is it giving you when you use the =COUNTIF([Project Phase]:[Project Phase], "Active")

Paul Newcome

Have you double checked that there are no filters applied to the source data?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.