# Revision history [back]

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