=SUMPRODUCT(ISNA(MATCH(A1:A7,{"RDO","S","V"},0))*( A1:A7<""))


"Teethless mama" wrote:

=SUMPRODUCT(--ISNA(MATCH(A1:A7,{"RDO","S","V"},0))*(A1:A7<""))


"MB" wrote:

I am trying to COUNTA rows of 7 cells that contain data. i do not want the
cells counted if they meet one or more conditions. For example:

count non blank cells that do not include one of the following text:

RDO
S
V

Can someone help. Have been trying for several hours and it is not sinking
in?