# adding more equation to column of existing equations

#### daveus

##### Board Regular
I don't know how to explain this the best, but i have a column of equations that sum or average different groups of cells, so none of them are the same. Instead of having to go into each one to add "/60", i would like to know if there is a way to add that easily to many rows of equations.

So, i have rows of info and they are grouped together. a merged cell right next to it has the sum of the cells in the adjacent column. Instead of having to go down and add divide by 60 to all of them individually, i would like to add /60 to them quickly. I hope this makes sense. Any suggestions.

example: cells e7-11 have 1,2,3,4,5. cells f7-11 are merged into one cell and contain the formula =average(e7:e11). I want to quickly make the cells =average(e7:e11)/60.

thanks for any suggestions. sorry to be so wordy, but it's hard to explain.

Dave

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi Dave,

Put this into a new module (Alt + F11, Insert > Module, Paste, Alt + Q)
To run, Alt + F8 and double-click the macro name. It will put /60 at the end of any formula in Column F.
Code:
``````Sub Test()
Dim c As Range
For Each c In Range("F:F").SpecialCells(xlCellTypeFormulas)
c.Formula = c.Formula & "/60"
Next c
End Sub``````
Denis

THANK YOU DENIS!!!

That is exactly what i was looking for but didn't know the two key row commands. Life saver! Thanks again. Learned something new today!

David

You're welcome

Denis

Replies
7
Views
302
Replies
1
Views
185
Replies
1
Views
182
Replies
1
Views
89
Replies
1
Views
494

1,217,756
Messages
6,138,425
Members
450,136
Latest member
Tabako1960

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back