So check out the table below...
John 0 1 Sally 0 0 Jane 1 1 Bill 1 0 Sue 0 0
I'm looking for a way to count the number of people who have a value greater than 0 in EITHER column 2 or column 3, without double counting the ones who have a value greater than 0 in both. So in this case, we need an output of three.
Any ideas?
Bookmarks