Countifs formula

Hi,

I am trying to count the number of cells that have CX Planned value on the reference of CX Status Column and at the same time CX Month reference should be dated as 03-01-22, below don't seem to be working, when i do separate countif formula they work but of course don't give what i want. What am I missing here?

=COUNTIFS({CX MONTH}, DATE(2022, 3, 1), {CX Status}, "CX Planned")

It gives me incorrect argument set error.

Find more posts tagged with

Formulas

Accepted answers

Cemil Binlik

Never mind, I found my answer, my first reference name was incorrect as I wrote it manually. It took me a while to figure it out, Thank you

All comments

Cemil Binlik

Never mind, I found my answer, my first reference name was incorrect as I wrote it manually. It took me a while to figure it out, Thank you

Genevieve P.

Glad you were able to figure it out! 🙂

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.