troubleshooting Question

refer formula to specific cell

Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
3 Comments1 Solution106 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros