We help IT Professionals succeed at work.
Get Started

refer formula to specific cell

Ian Bell
Ian Bell asked
on
103 Views
Last Modified: 2015-11-28
Hi,
I would like to have the below formula modified to refer to a range of cells.
=IF(A9=A8,T8,S9+COUNTIF($A$9:$A$2473,A9)-1)
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
Ian
ps..... or maybe there is a formula that can refer to the last row of a spreadsheet
Comment
Watch Question
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE