I’m having trouble finding a simple way to count “X”s marked in a row, but in specific columns.
On the left (highlighted in pink), I have various categories of “rope replacement reasons”, and on the right, there are columns to log each instance of rope replacements with “X” marking different reasons.
I want to add all instances of “core” marked with X on anchor #1, all “fuzz” marked with X on anchor #1, etc.
enter image description here
Below is the link to the file:
https://docs.google.com/spreadsheets/d/1B35V6e-boAl8XWPpPuTI6gaMI0CsdOgGHvwrT0a-PQM/edit?usp=drive_link
i’m not sure how to do this..
Chulho Chang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.