Invald Data type

Matthew 5

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?

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.