Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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)? |
#2
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |