Countif function within a specific month, what is my error

Hello all,

I'm beginning with the functions and I'm struggling here with this instance:

My objective is to add a chart to a dashboard, my information table is as follow, Basically I want to count the number of request per month and include them in a bar chart.

So, I made a calcsheet to extract the information to generate the chart.

I want to count the number of request made in november

So here is the formula I'm trying and on the following row, the error I get:

=COUNTIF({Date de la demande};(Month(@CELL) = 11)

Please let me know what I'm missing?

Thanking you in advance,

Chris

Find more posts tagged with

Accepted answers

Paul Newcome

@Brewso That leads me to believe you may have blanks or other non-date values within the date column. In that case you will need to work in an IFERROR like so:

=COUNTIF({Date de la demande}; IFERROR(MONTH(@cell), 0) = 11)

Paul Newcome

@Brewso Happy to help. 👍️

@Ray Lindstrom Some regions use semicolons in place of commas and commas in place of periods.

All comments

Ray Lindstrom

Paul Newcome

"@cell" is case sensitive. It must be all lowercase.

Brewso

Paul, thanks for the info.

It helped a bit but didn't solve it, I now have a different alert :

=COUNTIF({Date de la demande}; (MONTH(@cell)=11))

#INVALID DATA TYPE

Paul Newcome

@Brewso That leads me to believe you may have blanks or other non-date values within the date column. In that case you will need to work in an IFERROR like so:

=COUNTIF({Date de la demande}; IFERROR(MONTH(@cell), 0) = 11)

Ray Lindstrom

@Brewso,

I agree with @Paul Newcome, but with the change of the semicolon to a comma.

=COUNTIF({Date de la demande}, IFERROR(MONTH(@cell), 0) = 11)

Hope this helps!

BRgds,

-Ray

Brewso

Thanks a lot Paul and Ray,

It's working, I used a new table and start the data at the top of the columns which is working fine, then I went back to my original calcsheet and re-selected my range and now it works on both pages.

The function works with the semicolon but not with the comma.

Paul Newcome

@Brewso Happy to help. 👍️

@Ray Lindstrom Some regions use semicolons in place of commas and commas in place of periods.

Ray Lindstrom

@Paul Newcome,

Thanks for letting me know that about the regions having different formats (comma vs semi)! I was wondering how in the world a semicolon worked for one user, but failed in my testing before making my recommendation. Now I get it!

Appreciate you taking the time to let me know. 😊

Paul Newcome

@Ray Lindstrom No worries. I have to be very careful when I come across that because I am so used to using commas that I will put them in out of habit and then miss that as a problem when it doesn't work for someone. Haha

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.