Using COUNTIF in Summary

Hello

I'm looking to create a dashboard. I've got a column in a sheet that has 'Not Started', 'In Progress', 'Complete' as options. I could do with a report that shows 'Not Started' = x and 'In Progress' = y etc.

How do I go about this? Ideally I'd like to put Countif into the Summary rather than update it manually as the statuses could change quite a bit.

Any ideas or other methods as I can't see the wood for the trees at the momemnt...

Thanks

Katie

Find more posts tagged with

Accepted answers

All comments

Colleen Patterson

=COUNTIF(Column Name:Column Name, "Not Started") replacing the column name with the actual column name. The sheet summary would easily be able to hold these data values for you.

KatieDi

Hi Colleen,

This is great, thank you.

Do you now know how I add text to the end? I can obtain the result, e.g. 65, but I'd like the summary to say 65 Not Started.

Katie

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.