researcher

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

39 thoughts on “researcher

  1. longchamp handbags

    I precisely wanted to say thanks yet again. I’m not certain what I would have created in the absence of the suggestions discussed by you relating to such area of interest. It previously was an absolute fearsome problem in my opinion, nevertheless observing the very specialized technique you dealt with it took me to weep over fulfillment. I’m happy for this advice as well as believe you find out what a powerful job that you are getting into teaching the rest with the aid of your websites. Most probably you have never met all of us.

  2. yeezy boost

    I intended to send you a bit of word just to say thanks yet again with your splendid things you have documented above. This has been certainly strangely open-handed of people like you to provide openly what some people would have made available as an e book in order to make some cash on their own, certainly now that you might have tried it in case you decided. Those concepts in addition acted like the fantastic way to understand that some people have the same dream like mine to learn lots more when it comes to this issue. Certainly there are a lot more pleasurable instances ahead for individuals who read carefully your blog post.

  3. coach outlet online

    I am only writing to let you understand what a terrific experience my daughter experienced going through yuor web blog. She even learned so many pieces, not to mention what it is like to possess an awesome helping nature to have folks smoothly fully grasp chosen extremely tough matters. You actually exceeded people’s desires. Thanks for offering those essential, trustworthy, educational and in addition unique tips about that topic to Jane.

  4. balenciaga

    Thank you so much for providing individuals with such a wonderful possiblity to check tips from this site. It is usually so useful and also jam-packed with amusement for me personally and my office acquaintances to search your blog at a minimum 3 times a week to learn the new items you have. And definitely, I am also certainly fulfilled concerning the astounding points served by you. Certain two ideas in this article are really the most efficient we have had.

  5. hermes birkin

    My spouse and i were quite peaceful when Edward managed to finish off his reports using the precious recommendations he discovered out of the web pages. It’s not at all simplistic just to always be freely giving thoughts that other folks have been selling. And we also do know we have the writer to appreciate because of that. The main illustrations you’ve made, the easy site navigation, the relationships you will help create – it is all impressive, and it is aiding our son and us reason why this theme is exciting, and that’s especially important. Thank you for the whole lot!

  6. michael kors

    Thank you so much for providing individuals with an extraordinarily breathtaking chance to read articles and blog posts from this blog. It is always so terrific plus full of a great time for me and my office friends to visit your web site more than thrice every week to study the newest secrets you have got. And indeed, I am usually impressed considering the attractive opinions served by you. Some 4 areas in this posting are essentially the finest we have all ever had.

  7. air jordan

    I wish to show thanks to the writer just for rescuing me from this trouble. After researching through the the net and coming across tricks that were not helpful, I thought my entire life was gone. Living without the presence of solutions to the issues you’ve fixed all through the article content is a critical case, and ones which could have in a negative way affected my entire career if I hadn’t come across your web page. Your own personal mastery and kindness in dealing with the whole lot was tremendous. I am not sure what I would’ve done if I hadn’t encountered such a point like this. I can also at this time look ahead to my future. Thanks so much for the specialized and result oriented help. I won’t hesitate to recommend your web blog to any person who should get guide on this problem.

  8. sling tv

    Can I just say what a relief to find somebody who truly understands
    what they’re discussing on the web. You actually realize how to bring a problem to
    light and make it important. A lot more people must read this and understand this side
    of your story. I can’t believe you aren’t more popular given that you most certainly have the gift.

  9. supreme hoodie

    I simply wanted to make a quick note to be able to appreciate you for the pleasant steps you are sharing on this website. My particularly long internet research has at the end of the day been paid with good points to go over with my good friends. I would admit that most of us website visitors actually are truly fortunate to dwell in a decent site with very many marvellous individuals with helpful tips. I feel very grateful to have encountered your website and look forward to some more pleasurable moments reading here. Thanks a lot once again for everything.

  10. sling tv

    Hi all, here every one is sharing these kinds of experience, therefore it’s good to read this web site, and I used to visit
    this webpage everyday.

  11. sling tv

    Hi there, I found your blog by the use of Google while looking for a similar matter, your site got here up,
    it appears great. I’ve bookmarked it in my google bookmarks.

    Hi there, simply became alert to your weblog thru Google, and found that it is truly informative.
    I’m gonna be careful for brussels. I will be grateful in case you continue this in future.
    Numerous other folks will probably be benefited out
    of your writing. Cheers!

  12. sling tv

    Its such as you learn my thoughts! You seem to know
    a lot approximately this, like you wrote the e book in it or something.
    I believe that you just could do with some p.c. to drive the
    message house a bit, but instead of that, that is great
    blog. A fantastic read. I’ll definitely be back.

  13. curry 6 shoes

    Needed to write you that little word in order to thank you over again for the beautiful strategies you have provided on this website. This has been generous of people like you to convey unhampered all some people would’ve supplied as an ebook to make some dough for their own end, certainly seeing that you might well have done it if you ever decided. These guidelines also worked to become a great way to be certain that many people have the same keenness the same as my own to grasp a whole lot more regarding this problem. I am certain there are many more fun situations in the future for many who check out your site.

  14. jordans

    I am glad for commenting to let you understand of the extraordinary encounter my child encountered visiting the blog. She even learned several details, most notably how it is like to possess a very effective teaching style to get many others without problems learn about chosen advanced issues. You undoubtedly did more than our own expectations. Many thanks for offering such good, safe, edifying and even unique guidance on the topic to Sandra.

  15. michael kors

    Needed to create you one little remark in order to give many thanks the moment again considering the gorgeous methods you have shown on this site. It was quite unbelievably generous with people like you to allow openly just what many of us would’ve offered as an e book in order to make some money for themselves, notably considering that you could have tried it in the event you decided. These pointers in addition acted like the great way to be aware that other people online have the identical zeal really like mine to see great deal more regarding this condition. I am certain there are a lot more pleasant periods in the future for folks who look into your site.

  16. sling tv

    Having read this I believed it was rather enlightening.

    I appreciate you taking the time and energy to put
    this article together. I once again find myself personally spending a significant amount of time both reading and posting comments.
    But so what, it was still worth it!

  17. supreme

    Needed to draft you the very little remark to finally thank you the moment again relating to the nice suggestions you’ve featured in this article. It is certainly strangely open-handed with people like you to present extensively what exactly a number of us would have advertised for an e book to end up making some money for themselves, specifically considering that you might have tried it in the event you decided. Those advice in addition served to provide a great way to understand that someone else have the identical interest like my own to learn much more when considering this condition. I know there are a lot more pleasant times up front for people who read carefully your website.

  18. hermes belt

    Thanks so much for giving everyone such a terrific chance to read articles and blog posts from this site. It is always so pleasurable and jam-packed with amusement for me personally and my office fellow workers to visit your blog particularly 3 times weekly to learn the fresh stuff you have. Of course, I am also at all times satisfied with the unique methods served by you. Selected 3 facts on this page are basically the most suitable we have all ever had.

  19. goyard wallet

    A lot of thanks for your own hard work on this site. Kate takes pleasure in making time for investigations and it is easy to see why. All of us hear all about the lively tactic you present efficient items via your website and as well as inspire participation from other people on the issue plus our favorite daughter is now discovering a lot. Have fun with the rest of the year. Your performing a wonderful job.

  20. ps4 games

    I was recommended this web site by my cousin. I’m not sure whether this post is written by
    him as no one else know such detailed about my difficulty.
    You’re incredible! Thanks!

  21. quest bars cheap

    Please let me know if you’re looking for a author for
    your site. You have some really great posts and I
    think I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some content for your blog in exchange for a link back to mine.

    Please blast me an e-mail if interested.
    Many thanks!

  22. nike air max 270

    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.

  23. this coconut oil

    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

  24. http://tinyurl.com

    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!

  25. curry 4

    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.

Comments are closed.