I've attached a spreadsheet of my issue.
There are several variations of outcomes for a patient. I'm wanting to count if an L (lowercase in the worksheet) is present in 1 of 3 columns, if so it counts as 1.
Example if BAB1 = l & BAB2 = l then that counts as 1, not 2. Basically wanting to count if a patient has an l among 3 columns, if so it = 1.
The answer should be 7 in the example spreadsheet I have attached.
Please someone help!
Bookmarks