J
JRD
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
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