SOLVED

Formula for counting false based on column

Copper 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!
1 best response

Accepted Solutions
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.

View solution in original post