thanks for the welcome

Unfortunately thought the solutions not quite that simple. Some pieces of equipment have 2 entries (both of which will say rehab, defect, readiness ot whatever) so if i just counted defect or rehab i'd end up with two many.

What I need to do is count the number of unique instances of rehab or defect (their uniqueness decided by the value in column A).