Avatar of Ian Bell
Ian Bell
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

refer formula to specific cell

I would like to have the below formula modified to refer to a range of cells.
The above range shows a9:a2473. However the end range can change from sheet to sheet.
row 9 is always the same. The latter part only needs modifying from Countif.....
At the moment the other cell formulas just refer to a cell with 2473 or whatever number of rows there are in the sheet
and I would like to do the same with the above formula rather than having to modify each time.
Any help much appreciated.
Thank You
ps..... or maybe there is a formula that can refer to the last row of a spreadsheet
Microsoft Excel

Avatar of undefined
Last Comment
Ian Bell

8/22/2022 - Mon