I have a spreadsheet with the following in columns:
A - Name
B - Test 1
C - Test 2
D - Test 3
E - Test 4
Is there a way to create Column F to be the count of how many tests have been completed for that particular person.
A person may have completed any none, or any combination of the 4 tests. For example, if John Doe has completed Test 1 and Test 3, his count would be 2. If Jane Doe has completed Test 2 - 4, her count would be 3. If A. Williams has completed no tests, his count would be zero.