Count value in columns

Hello,   I have something like this:   Client col1 col2 col2 c1 OK OK OK c2 OK OK CRIT c3 WARN WARN OK c4 OK OK OK c5 OK CRIT OK c6 WARN OK OK c7 OK ...