<div>
what are the values under columns test 1 - 4?<br />
do you want to do this in excel or access?
</div>


what are the values under columns test 1 - 4?
do you want to do this in excel or access?

<div>
if the values for test taken is &quot;Y&quot;, <br />
in the Excel workbook, you can place this formula in Column F, row 2<br />
<br />
=COUNTIFS(B2:E2,&quot;=y&quot;)<br />
<br />
and should get the counts.
</div>


if the values for test taken is "Y",
in the Excel workbook, you can place this formula in Column F, row 2

=COUNTIFS(B2:E2,"=y")

and should get the counts.

<div>
<div class="content wysiwyg-content">
I have a spreadsheet with the following in columns:<br />
<br />
A - Name<br />
B - Test 1<br />
C - Test 2<br />
D - Test 3<br />
E - Test 4<br />
<br />
Is there a way to create Column F to be the count of how many tests have been completed for that particular person.<br />
<br />
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.<br />
<br />
Thank you
</div>
</div>


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.

Thank you

Access - count non-empty cells across a row

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.