I have a set of values say 38 data points, each data point is category 1 or 2. I need to do a moving average of the last 6 values(from bottom to top so to speak) that have a category of 1. I will not know which category is present for each data point at the time of writing the formula . The user will enter the values one at a time over a long period of time. The moving average needs to update after each input(if relevent, if the correct category is entered)
Could you post a sample workbook, please - it would make it much easier to understand the issue you're trying to solve.
Hello
from your sample file
try in D7 - drag down.
=AVERAGEIF(C3:C8,1,B3:B9)
don't put $ signs
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
jdm, please take a few minutes to read the forum rules about crossposting and then do as they request.
Thanks.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks