Changing cell References by fixed value

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,622
Office Version
  1. 2019
Platform
  1. Windows
I have a series of formula copies from another workbook, but need all the references to be reduced by 10

for Eg for original formula which was copies is =SUM(INDEX(Sheet1!A1671:DG1671,0,104))

I need this automatically reduced by 10 for eg =SUM(INDEX(Sheet1!A1661:DG1661,0,104))

Is there a way in Excel where I can reduce a the values in the range by say 10

Your assistance will be most appreciated
 

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,622
Office Version
  1. 2019
Platform
  1. Windows
Hi Fazza

Thanks for the aditional info regarding my posting

Regards

Howard
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,108,482
Messages
5,523,207
Members
409,504
Latest member
Joshcurrie

This Week's Hot Topics

Top