=COUNTIFS({SP Migration Sentiment Range 8),wave1,{SP Migration Sentiment Range 3}, <8, {SP Migration Sentiment Range 3},
Need help on this formula. Ultimately, need to count value between 4~7 along the value of Wave 1
Are you able to provide screenshots with sensitive/confidential data removed, blocked and/or replaced with "dummy data" as needed?
Hello Paul. I figured it out. I would just need to continue to add range, and criterion to break out the condition. Thank you for your time responding.
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.