Why is my countifs formula not working

This works

=COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1)

But this gives an incorrect argument error

=COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1), {Event Management Sheet Range 12}, 1)

Find more posts tagged with

Countif

Accepted answers

bisaacs

Hey @mleesc,

In this instance, I think there's something wrong with the range of Range 12. So each range in the formula only covers 1 column each, but do they cover the same # of rows? If the Range 12 doesn't cover the same # of rows/columns, it would throw an incorrect argument. This works:

=COUNTIFS(Test:Test, 123, [Column7]:[Column7], 1)

But this would throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Column7]1:[Column7]25, 1)

This would also throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Test 2]:[Column7], 1)

Hope this helps!

All comments

bisaacs

Hey @mleesc,

What's the column type for the Range 12 you're looking at? Is it the same # of columns in the rest of the COUNTIFS formula?

mleesc

@bisaacs Range 12 is a Text/Number Column. Range 3 is a Text/Number Column, Range 7 is a data column

bisaacs

Hey @mleesc,

=COUNTIFS(Test:Test, 123, [Column7]:[Column7], 1)

But this would throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Column7]1:[Column7]25, 1)

This would also throw an INCORRECT ARGUMENT error:

=COUNTIFS(Test:Test, 123, [Test 2]:[Column7], 1)

Hope this helps!

mleesc

@bisaacs Thanks that was the problem

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.