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

10 thoughts on “researcher

  1. 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.

  2. 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!

  3. 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

  4. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *