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?
 =COUNTA(H22:O22)-SUMPRODUCT((H22:O22={"y","-"})*1)

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

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

Open in new window

0
 
Ryan ChongCommented:
quick fix would be:

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

Open in new window


or:

=COUNTA(H22:O22)-(COUNTIF(H22:O22,"y")+COUNTIF(H22:O22,"-"))

Open in new window

0
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.