Frank .S
asked on
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)-SUMPRODUC T((H22:O22 ={"y","-"} )*1)
can you see any issues with the formula?
=COUNTA(H22:O22)-SUMPRODUC
can you see any issues with the formula?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
or:
Open in new window