CountIF formula with 3 criteria help please

ealexis

Hello,

I am trying to use the CountIF formula with 3 criteria.

1st criteria: date needs to between between 12/31/2023 and 5/5/2024

2nd criteria: intake status needs to be not blank

3rd criteria: must match zip code

I am getting "incorrect argument set". Can anyone help?

This is my formula below:

=COUNTIFS({BROWARD UP REQUEST INFORMATION created}, >=DATE(2023, 12, 31), {BROWARD UP REQUEST INFORMATION created}, <=DATE(2024, 5, 5), {Intake Status}, <>"", {zipcode}, "33309")

Find more posts tagged with

Accepted answers

All comments

AravindGP

Hi @ealexis

You shouldn't specify a number in quotes. Try this instead

=COUNTIFS({BROWARD UP REQUEST INFORMATION created}, >=DATE(2023, 12, 31), {BROWARD UP REQUEST INFORMATION created}, <=DATE(2024, 5, 5), {Intake Status}, <>"", {zipcode}, 33309)

ealexis

@AravindGP unfortunately that did not work.

KPH

Hi, Your syntax looks fine. It is probably an issue with the cross-sheet references, which we cannot see.

Please check that all of those references are in the same sheet, and are the same size/shape (for example if one is only 10 rows, they must all be only 10 rows).

ealexis

Hello @KPH

All of the references are indeed in the same sheet, and have the same amount of rows.

KPH

I'm not sure what to suggest next. Can you try re-building the cross sheet references? Just in case something weird has happened to them.

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.