Actually, it is not quite what I am after as in this formula there still is
the hard-coded column E.
The column E should be produced by the COUNTIF.
It looks close though.

RBS

"Bob Phillips" wrote in message
...
=COUNTA(INDIRECT("A"&COUNTIF($2:$2,"3Morb_3*")&":E "&COUNTIF($2:$2,"3Morb_3*"
)))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"RB Smissaert" wrote in message
...
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