Can anyone see the error in my formula. =IF($Help$1 >= April$1, COUNTIFS({888 - Job Progress Slab}, Date([Help Lot Size]1, March1,1)) + COUNTIF(OR({888 - Job Progress Contract Date}, >Date([Help Lot Size]1,March1,31), {888 - Job Progress Contract Date}, "")), “”)

OR Statements

Can anyone see the error in my formula.

=IF($Help$1 >= April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE(2024, April$1, 31), {888 - Job Progress Origination Note}, = "Spec") + COUNTIF(OR{888 - Job Progress Final CO}, "", {888 - Job Progress Final CO}, >Date([Help Lot Size]1, March1,1)) + COUNTIF(OR({888 - Job Progress Contract Date}, >Date([Help Lot Size]1,March1,31), {888 - Job Progress Contract Date}, "")), “”)

Find more posts tagged with

Accepted answers

All comments

dojones

You are missing a cell reference in the COUNTIF(OR(…

There should be a Range or Cell before OR with comma before OR. Below is an example.

=COUNTIF([Raid Item Type]:[Raid Item Type], OR(@cell = "PMO", @cell = "Change Enablement"))

Robert S Fike

=IF($Help$1 >= April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE(2024, April$1, 31), {888 - Job Progress Origination Note}, = "Spec") + COUNTIF({888 - Job Progress Final CO}, OR({888 - Job Progress Final CO}, "", {888 - Job Progress Final CO}, >Date([Help Lot Size]1, March1,1))) + COUNTIF({888 - Job Progress Contract Date}, OR({888 - Job Progress Contract Date}, >Date([Help Lot Size]1,March1,31), {888 - Job Progress Contract Date}, "")), “”)

Tried this, but still UPARSEABLE. Thougths?

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.