Basically, I need to count non-blank cells in a row and I need to skip certain columns/cells in that row. I'm sure this is simple combination of functions but I can't seem to find a solution to this.


2 Answers 2


=COUNTA( {I28:K28, M28, N28} )



If, e.g., you mean to count non-blank cells in row 1, excluding columns E:F and cell H1, use


The needed changes for other uses are obvious.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.