Moving Average with conditions

[jdm2008]

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)

[Andrew-R]

Could you post a sample workbook, please - it would make it much easier to understand the issue you're trying to solve.

[jdm2008]

Moving Average.xlsxMoving Average-excel forum.xls

[vlady]

Hello
from your sample file
try in D7 - drag down.

=AVERAGEIF(C3:C8,1,B3:B9)

don't put $ signs

[shg]

jdm, please take a few minutes to read the forum rules about crossposting and then do as they request.

Thanks.