COUNTIFS with multiple string variables

Question

I am trying to track for a sales tracking sheet the following but it is not working.

Here is what I have so far

=COUNTIFS(J10:J, "offer & didn't buy", J10:J, "follow-up & didn't buy", J10:J, "follow-up & no show")

COUNTIFS takes conditions as AND not OR. Do you mean OR (i.e., count if ANY of those strings are an exact match)? — Erik Tyler
– Erik Tyler, Commented Mar 10, 2021 at 23:26

Erik Tyler · Accepted Answer · 2021-03-10 23:34:34Z

1

COUNTIFS criteria work on an AND basis, not OR. If you mean "Count cells in J10:J that contain any of these three exact strings," then try this:

=COUNTA(FILTER(J10:J, NOT(ISERROR(REGEXEXTRACT(J10:J,"offer & didn't buy|follow-up & didn't buy|follow-up & no show")))))

COUNTA will count everything that is not blank/null in the given range (real or virtual).

The formula creates a FILTERed range for the COUNTA to count. That range includes only entries where REGEXEXTRACT tries to extract one of the three target strings and does not return an error, i.e., NOT(ISERROR(...)).

answered Mar 10, 2021 at 23:34

Erik Tyler

9,3952 gold badges9 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

COUNTIFS with multiple string variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related