OR Syntax

Jason Wirl

Hello Community,

What's wrong with my syntax below:

=COUNTIF(OR([Column 1]:[Column 1], CONTAINS("A", @cell)), [Column 1]:[Column 1], CONTAINS("B", @cell))

If it's not obvious, want a count from Column 1 when "A", or "B" are present.

Error is "#INCORRECT ARGUMENT SET" if it helps.

Jason

JLC

@Jason Wirl I think what you're looking for is this:

=COUNTIFS([Column 1]:[Column 1], (OR((CONTAINS("A", @cell)), (CONTAINS("B", @cell)))))

Haven't tested; let me know how you fare!