end of column refence in several calculations
 

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)?

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

--
Regards
Frank Kabel
Frankfurt, Germany

James Garlock wrote:
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)?