SOLVED

Excel formula related ti COUNTIFS function

%3CLINGO-SUB%20id%3D%22lingo-sub-2672650%22%20slang%3D%22en-US%22%3EExcel%20formula%20related%20ti%20COUNTIFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672650%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20need%20to%20find%20out%20three%20things%3A%3C%2FP%3E%3CP%3E1.%20How%20many%20people%20have%20taken%20at%20least%20one%20test%3F%3C%2FP%3E%3CP%3E2.%20How%20many%20people%20have%20taken%20both%20tests%3F%3C%2FP%3E%3CP%3E3.%20How%20many%20people%20have%20taken%20neither%20tests.%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672716%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20related%20ti%20COUNTIFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3BSee%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

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 Replies
best response confirmed by Zan_Hanifee (Regular Contributor)
Solution

@Zan_Hanifee See attached.

Thank you so much sir