Excel formula related ti COUNTIFS function

[Excel]

Hello Everyone,

I need to find out three things:

1. How many people have taken at least one test?

2. How many people have taken both tests?

3. How many people have taken neither tests.?

Please help..??

Here is a attached file..

[#2 · Accepted solution]

@Excel See attached.

[#3]

Thank you so much sir:smiling_face_with_smiling_eyes: