COUNTIFS FORMULA with Cross Reference and MONTH Date

I would be most appreciative for help on this formula. I am cross referencing data from another sheet and trying to count how many times TM & AM pop up in the month of February. I keep getting the UNPARSEABLE error.

=COUNTIFS({GCS Service Lines},("TM & AM", @cell)>0, MONTH,{Date Created}(@cell)=2)

Thanks in advance for your help!

Find more posts tagged with

Accepted answers

All comments

Luis Montanha

Hi, @Jenn Glass!

Try this: =COUNTIFS({GCS Service Lines}, "TM & AM", {Date Created}, MONTH(@cell) = 2)

Let me know how that goes!

Jenn Glass

Hi @Luis Montanha - it's still not working, but now we are getting somewhere... the answer calculates as 0... which is what happened in the previous column where I was just counting the number of TM & AM without adding on the month. When adding the ("TM & AM", @cell) > 0.... I was able to calculate the actual count.

I wish I was better at this stuff, but trying hard at learning. Any other suggestions?

Jenn Glass

Does it matter if the "Date Created" column is an auto-generated date from a form? Maybe that is what is preventing the MONTH formula?

Kelly Moore

Hey @Jenn Glass

The formula should work as written, even with the system generated Created field. Is your term "TM & AM" written exactly as it is in your data - including the capitalization? I'm sure @Luis Montanha will have more suggestions for troubleshooting

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.