Invald Data type

Good afternoon,

The following formula is throwing an Invalid Data Type..

=COUNTIFS(District:District, District@row, OR(Status:Status, @cell = "pending", [Actual_PWE]:[Actual_PWE], @cell > TODAY(-30)))

The District is Text, Status is text in a drop down, and Actual_PWE is a Date which gets its value from from another cell in the same sheet and is supposed to be updated at a later time.

Not sure what is causing the error so I can correct it, any hints?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

What logic are you wanting to accomplish?

Matthew 5

@Paul Newcome

Trying to collect a count of each district in the list that has a "Pending" status or a Date that meets the criteria. The expected results will get used on a different sheet to show locations with different statuses. By necessity this needs to be a sheet because the fields Actual_PWE and Status get updated manually by the user...

So I need to count Districts if the Status = "Pending" or Actual_PWE more than 30 days old.

Paul Newcome

The easiest way to do this would be to use a checkbox column on the source sheet with an IF/OR to check the box on every row that meets this criteria.

You can do it without this, but to avoid a double count you need to write out three separate COUNTIFS statements, add two together and then subtract the third.

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.