Count Formula_3

hi experts when using this formula in a row range of cells instead of a column range of cells, it produces a #N/A error?

can you see any issues with the formula?
Frank .SBuilding EstimatorAsked:
Who is Participating?
Ryan ChongConnect With a Mentor Commented:
or try this:


Open in new window

Ryan ChongCommented:
quick fix would be:

=COUNTA(H22:O22)-(SUMPRODUCT((H22:O22="y")*1) + SUMPRODUCT((H22:O22="-")*1))

Open in new window



Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.