Forum Discussion

mesmrc's avatar
mesmrc
Copper Contributor
May 18, 2021
Solved

COUNTIFS help

I'm having trouble nailing the right formula for counting the number of filled-in cells in an entire column that *do not* include the text "SKIP" (in that exact formatting), and also don't include an...
  • HansVogelaar's avatar
    May 18, 2021

    mesmrc 

    For column C:

     

    =COUNTIFS(C:C,"<>SKIP",C:C,"<>")

Resources