SOLVED

COUNTIFS help

Copper 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 (Copper Contributor)
Solution

@mesmrc 

For column C:

 

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

You're the best Hans! Much appreciated.
1 best response

Accepted Solutions
best response confirmed by mesmrc (Copper Contributor)
Solution

@mesmrc 

For column C:

 

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

View solution in original post