end of column refence in several calculations

[Guest]

I have several caculations (countif) that are based on the last-row of a
single column. So if column-A ends at row 120 how can I reference that
location automaticlly in my caculations without having to manually update the
row refence in all my caculations (example: =COUNTIF($BH$3:$BH$xxx,BP2) where
xxx is 120)?

 

[Frank Kabel]

Hi
if you have no blank rows in between try:
=COUNTIF(OFFSET($BH$3,0,0,COUNTA($BH:$BH)-2),BP2)
if also rows 1 and 2 are filled