Hi John,

=COUNTIF(B1:INDIRECT("B"&A1),"PCI")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"JRD" wrote in message ...
| Can anyone tell me whether I can put a number in a cell and then use that
| cell to define a range
|
| e.g.
|
| A B
| 1 3 CABG
| 2 PCI
| 3 CABG
| 4 PCI
|
| =countif(B1:B(A1), "PCI")
|
| The answer should equal 1
|
| Thanks
|
| John
|