hello, I'm trying to make a formula where 1 column is ERR (error) the other is OBS (observation). on the right side of theses colums there are error codes from for example cell U12error code is 01-01-01 up to cell FO12 error code is 01-01-21.
so if a reviewer puts a ERR in 01-01-01cell (U12) and a OBS in 01-01-21cell (FO12) in the same row, I want it to show a 1 in the ERR column and a 1 in the OBS column on that same row. So to reconfirmed the colums have to be the sum of all ERR or OBS compiled in a single row.
How do I do this
thank you
Bookmarks