Forum Discussion
Solved
Formula for counting false based on column
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!
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!
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.
2 Replies
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!
