Try this...

=COUNTA(A1:J1)-SUM(COUNTIF(A1:J1,{"D","S","M"}))

--
Biff
Microsoft Excel MVP


"ExcelforDummies" wrote in
message ...
I have a work schedule and im trying to show days off. the rows consist of
D
for days, S for swings and M for mids. I am trying to show on another
colum
the number of days that a row does not contain a d,s, or m but will count
everything else as 1 and give me a total.