Dear All,
I’m pretty new to Excel and appreciate any guidance regarding the following issue that I encounter; In the following, I have a row (in orange) of numbers; What I want to be in the second row (in blue) is the sum of the last “X” number of elements; Meaning that for X=4, as long as the number of values in the first row is less than X=4, the second row will show the sum of the non empty cells in the first row and once the X+1 cell (5 for this example) gets filled with a value, the very first entry in the first row is subtracted from the sum; for the next coming value in cell X+2 of the first row, the second entry in the first row is subtracted from the sum and so on.
Hence, we have a moving average of sum of last X number of elements shown in the second row and in case the number of elements in the first row is less than X it doesn’t give an error but instead sum of the available entries.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
1=1 | 3=1+2 | 6=3+3 | 10=6+4 | 14=10+5-1 | 18=14+6-2 | 22 | 26 | 30 | 34 | |
What is the fucntion doing this moving accumulated sum of the last X elements?
Thanks beforehand for any help.
Best,
Mary.
By: mary
very good post, i certainly love this web site, keep on it
This actually answered my downside, thanks!
Can I just say what a relief to seek out someone who truly is aware of what theyre speaking about on the internet. You undoubtedly know learn how to bring a problem to mild and make it important. Extra people have to read this and understand this facet of the story. I cant imagine youre no more well-liked because you undoubtedly have the gift.
Hey there this is kinda of off topic but I was wondering if blogs use WYSIWYG
editors or if you have to manually code with HTML.
I’m starting a blog soon but have no coding skills so I wanted to get guidance from someone with experience.
Any help would be greatly appreciated!
Hey! I simply want to give a huge thumbs up for the nice information you may have here on this post. I will likely be coming again to your weblog for more soon.
I think this is among the most important information for me.
And i am glad reading your article. But want to remark on few general things, The website
style is ideal, the articles is really excellent : D. Good job, cheers
Hello, everything is going sound here and ofcourse every one is sharing data, that’s genuinely excellent, keep up writing.
The following time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I know it was my choice to learn, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about one thing that you possibly can repair for those who werent too busy on the lookout for attention.
This post gives clear idea for the new visitors
of blogging, that actually how to do blogging.
you have an important weblog right here! would you like to make some invite posts on my blog?