Counting a column with multiple selection and Dates per month

Hello,

I am trying to reference another sheet to count the number of times the following "Other, NA, and Blanks has been entered per month "Example for July, August, etc". Any help would be greatly appreciated.

GPO.jpg

Dates.jpg

"Example Other, NA, and Blanks"

Find more posts tagged with

Accepted answers

Jeff Reisman

@William Evans try this for the month of July:

=COUNTIFS({Other Sheet Assigned Date Range}, MONTH(@cell) = 7, {Other Sheet GPO Range}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell)))

William Evans

Jeff, I used the following formula =COUNTIFS({Date Received}, MONTH(@cell) = 7, {GPO}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell))) and I am getting "Invalid Data Type

All comments

Jeff Reisman

@William Evans try this for the month of July:

=COUNTIFS({Other Sheet Assigned Date Range}, MONTH(@cell) = 7, {Other Sheet GPO Range}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell)))

William Evans

Jeff, I used the following formula =COUNTIFS({Date Received}, MONTH(@cell) = 7, {GPO}, OR(@cell = "Other", @cell = "NA", ISBLANK(@cell))) and I am getting "Invalid Data Type

William Evans

Jeff thanks it works now!

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.