Forum Discussion

PsychoEagleEyes's avatar
PsychoEagleEyes
Copper Contributor
Jun 24, 2021
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...
  • HansVogelaar's avatar
    Jun 24, 2021

    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.

Resources