combine CountA and CountIf
How in a worksheet formula would I combine these 2:
=COUNTIF($2:$2,"3Morb_3*")
and
=COUNTA(A7:E7)
where the result of the first formula would provide the column number for
the second formula?
So, if the first formula produced 5 the second one would be right.
RBS
|