Forum Discussion
PsychoEagleEyes
Jun 24, 2021Copper Contributor
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...
- Jun 24, 2021
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.
HansVogelaar
Jun 24, 2021MVP
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.