adding more equation to column of existing equations

daveus

Board Regular
Joined
May 18, 2004
Messages
191
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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

daveus

Board Regular
Joined
May 18, 2004
Messages
191
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
 

Forum statistics

Threads
1,136,512
Messages
5,676,289
Members
419,618
Latest member
Grisego

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top