SOLVED

Formula for counting false based on column

%3CLINGO-SUB%20id%3D%22lingo-sub-2481105%22%20slang%3D%22en-US%22%3EFormula%20for%20counting%20false%20based%20on%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2481105%22%20slang%3D%22en-US%22%3EHello%20everyone!%3CBR%20%2F%3EI%20am%20looking%20for%20help%20to%20create%20a%20table%20that%20will%20count%20the%20number%20of%20falses%20based%20on%20the%20number%20that%20is%20in%20the%20left%20column.%20I%20want%20to%20have%20the%20sheet%20look%20for%20a%20number%20in%20column%20C%20and%20then%20see%20if%20column%20D%20has%20a%20false.%20I%E2%80%99ve%20tried%20multiple%20things%20with%20the%20Countif%20function%20and%20the%20lookup%20function%20but%20I%20can%E2%80%99t%20get%20anything%20to%20work.%20Any%20else%20or%20guidance%20is%20appreciated!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2481105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2481158%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20counting%20false%20based%20on%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2481158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1087180%22%20target%3D%22_blank%22%3E%40PsychoEagleEyes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20in%20row%204%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS(%24C%244%3A%24C%241000%2C%24C4%2C%24D%244%3A%24D%241000%2CFALSE)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20last%20row%20(1000)%20if%20needed.%20Then%20fill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2481239%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20counting%20false%20based%20on%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2481239%22%20slang%3D%22en-US%22%3EThat%20worked!%20I%20feel%20like%20an%20idiot%20now!%20Thank%20you!%3C%2FLINGO-BODY%3E
New Contributor
Hello everyone!
I am looking for help to create a table that will count the number of falses based on the number that is in the left column. I want to have the sheet look for a number in column C and then see if column D has a false. I’ve tried multiple things with the Countif function and the lookup function but I can’t get anything to work. Any else or guidance is appreciated!
2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@PsychoEagleEyes 

Perhaps in row 4

 

=COUNTIFS($C$4:$C$1000,$C4,$D$4:$D$1000,FALSE)

 

Change the last row (1000) if needed. Then fill down.

That worked! I feel like an idiot now! Thank you!