Cant drag formula down column

[help needed yes please]

I am not much good at this and any help would be appreciated.
I can’t drag formula down column.
=Sum($E59:E164)/105
=Sum($E59:E165)/106 Note division is Ascending by each entry
Drag gives: =Sum($E59:E164)/105
=Sum($E59:E165)/106 which is correct
=Sum($E59:E166)/105 XXXXXX
=Sum($E59:E167)/104 XXXXXX
Dragged entries reduce the division with leach new entry
Any advice?

 

[shg]

[table="width:, class:grid"][tr][td="bgcolor:#c0c0c0"][/td][td="bgcolor:#c0c0c0"]

e​

[/td][td="bgcolor:#c0c0c0"]

f​

[/td][td="bgcolor:#c0c0c0"]

g​

[/td][td="bgcolor:#c0c0c0"]

h​

[/td][/tr][tr][td="bgcolor:#c0c0c0"]

59​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

60​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

160​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

161​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

162​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

163​

[/td][td]

105​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

164​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

106.0000​

[/td][td="bgcolor:#ccffcc"]f164: =sum($e59:e164) / (rows(e$164:e164) + 104)[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

165​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

105.0000​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

166​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

104.0187​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

167​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

103.0556​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

168​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

102.1101​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

169​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

101.1818​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

170​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

100.2703​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

171​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

99.3750​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

172​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

98.4956​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

173​

[/td][td]

105​

[/td][td="bgcolor:#ccffcc"]

97.6316​

[/td][td][/td][td][/td][/tr]
[/table]

 

[help needed yes please]

Thank you ‘shg’ for your efforts to help me. I tried to do as suggested but mucked up! I have tried to better explain. The formulas in Cells J 161 to J165 work to give the right numbers in J161 to J165 and adjust in ascending sequence. Cell A D E J 59l 161 10/8/2018 25031 120 245 Column J Cell 161 formula: =SUM($E59:E161)/103 162 11/8/2018 25031 0 242 Column J Cell 161 formula: =SUM($E59:E162)/104 163 12/8/2018 25031 0 240 Column J Cell 161 formula: =SUM($E59:E163)/105 164 13/8/2018 25901 870 246 Column J Cell 161 formula: =SUM($E59:E164)/106 165 14/8/2018 26061 160 245 The above gives ascending cell and division which is correct. When I highlight Cells J164 & J165 then drag Column ‘J’ Formula down the ascending formula goes haywire as below: Reference to $E59 gone, GIVES $e161 & $e163 & division counts down when it should be adding entry made. J 166 =SUM($E61:E166)/106 J167 =SUM($E61:E167)/107 J168 =SUM($E63:E168)/106 J169 =SUM($E63:E169)/107 Please bear with me (Don’t know how to give image like you did)

 

[Peter_SSs]

(Don’t know how to give image like you did)

Check out the links in my signature block below.

 

[help needed yes please]

Shg. Re your post formula: . =Sum($E59:E164) / (rows(E164:E164)+ 104 Excel would not accept the section beginning with the + And I need the F column to be ascending. Not descending as shown IE: Each new entry adds itself to formula in E and also to the division number as shown in my first post.
Thank you my friend for your patience

 

[help needed yes please]

Thanks Peter, I installed the MrExcel HTML Maker 20170807. But could not find on the toolbar or anywhere else an ‘Addons’ option for excel. So I placed it into its own folder under ‘Programs’. Will have to keep looking for that option and how to use it. Cortana can’t even find it on my computer? Probably seems so simple to you. Guess its always simple when you know how? That bit about one being a 'Work in progress' comes to mind. You have a kind lovely day, thanks Peter.

 

[help needed yes please]

shg: the post number 3 is hard to read as it shows. I found if i copied the post then pasted it on a word page it is way easier to read that way. Hope this helps. Thanks.

 

[Peter_SSs]

But could not find ... an ‘Addons’ option for excel. So I placed it into its own folder under ‘Programs’.

The Add-In file can go anywhere so where you have put it should be fine, so long as you know where it is for these two steps:

• In Windows Explorer, track to the file you have just saved to the Addin's folder, right click & choose Properties. On the 'General' tab look down the bottom to see if you need to 'Unblock' the file and do so if that option is available.

• Go to excel, invoke the Addin's dialog and locate the addin in the list. If it is not there then click browse and locate the addin. Place a check-mark beside the addin, if not already checked.

 

[shg]

If you put a workbook on box.net or dropbox and post a link I'll take a look. Please enter the correct desired formula in several rows manually and tell me where to find them.

 

[help needed yes please]

Peter i did as suggested and there was an unblock box which i applied. Closed the computer down to ensure activation of changes. Under the Addins of excel the Excel Html Maker is not showing however. I cant see a 'Browse' option so i seem to have hit a wall on that.