Hi Roy,

I would create some additional columns; One for each of the criteria Harm
Red Fully Ach etc and use the names as column headers. In your example they
would be columns G to K with the column headers
Harm Red, Fully Ach, Partly Ach, Not Ach, Abstinence

In cell G2 insert =COUNTIF($A2:$F2,G$1)
Note absolute ($signs) on the columns for $A2:$F2 and absolute on the row
for G$1.
Copy the formula across to column K and down for the length of your data.

Now to count the Harm Red and Fully Ach across the row.
In Cell L2 insert =COUNTIFS(G2,"0",H2,"0")

Copy this formula down for the length of your data.
Sum column L for the total answer.

You can add additional columns like L for counts of other combinations.

--
Regards,

OssieMac