Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

You have to escape the character - ("between" operator, see help)

=COUNTIFS(A1:A7; "[A?\-|D?_]"; B1:B7; "[A?\-|D?_]")

Regards

Hi

[EDIT]

I delete my answer that does not correspond to the need of the OP

You have to escape the character - ("between" operator, see help)

=COUNTIFS(A1:A7; "[A?\-|D?_]"; B1:B7; "[A?\-|D?_]")

Regards