Calculating how many time a value shows up in a column in a certain month

I have tried the formulas on here suggested to figure out how many times the word transfusion showed up in the Code column on a Date column February. I keep getting unparsable or invalid ref# . I even tried the IFERROR in case I had blanks but no go.

I was able to figure out how many times the word transfusion showed up in the Code column in the Department of MCWH. See my data below.

=COUNTIFS(Code1:Code20, "Transfusion", Department1:Department20, "MCWH")

I am very confused about what the Month(@cell) thing is?

Thanks,

Nicole

Find more posts tagged with

Accepted answers

Darren Mullen

https://youtu.be/KchiWBgsv4A

@Felkernic

Nicole,

See if my video explaining the @cell operator helps:

All comments

Darren Mullen

https://youtu.be/KchiWBgsv4A

@Felkernic

Nicole,

See if my video explaining the @cell operator helps:

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