VBA code for summiation in MS Excel

Hello There,

I am wiritng a macro and got struck badly.
I have a data from Cell C4 to Dxxx (column D is given as xxx because each day the number of rows get changed).
In column E, i have given the below code

Please Login or Register  to view this content.

Now I am trying to give a Formula in column F but getting struck here...
If Cell E4<>0,Sum($E$3:E4)
when it's comes to Cell E5 and if E5<>0,sum($E$3:E5)

This forumla should be there in all cells which has values in Column E

As said, the number of rows differs each time.

Any assistance is highly appreciated!!!

Thanks!

Please:

1) use code tags to comply with the forum rules and
2) upload a sample workbook

Regards, TMS

Add in the line in red:

Please Login or Register  to view this content.

I would appreciate it if you would edit the original post in this thread and add code tags to comply with forum rules. Strictly speaking, we are not supposed to answer questions that do not comply with the forum rules.

Adding code tags makes it easier for contributors to copy the code, if necessary. Uploading a sample workbook, whilst not always essential, will ensure that contribitors can see what you are working with and the solution is more likely to be fit for purpose.


Regards, TMS




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Please note that the solution did not come from me, it was from OllyXLS