SOLVED

COUNTIFS help

%3CLINGO-SUB%20id%3D%22lingo-sub-2365354%22%20slang%3D%22en-US%22%3ECOUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365354%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20trouble%20nailing%20the%20right%20formula%20for%20counting%20the%20number%20of%20filled-in%20cells%20in%20an%20entire%20column%20that%20*do%20not*%20include%20the%20text%20%22SKIP%22%20(in%20that%20exact%20formatting)%2C%20and%20also%20don't%20include%20any%20blank%20cells.%20Really%20appreciate%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2365354%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365370%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F894985%22%20target%3D%22_blank%22%3E%40mesmrc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20column%20C%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS(C%3AC%2C%22%26lt%3B%26gt%3BSKIP%22%2CC%3AC%2C%22%26lt%3B%26gt%3B%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365378%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIFS%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365378%22%20slang%3D%22en-US%22%3EYou're%20the%20best%20Hans!%20Much%20appreciated.%3C%2FLINGO-BODY%3E
Occasional Contributor

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 any blank cells. Really appreciate the help!

2 Replies
best response confirmed by mesmrc (Occasional Contributor)
Solution

@mesmrc 

For column C:

 

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

You're the best Hans! Much appreciated.