do not calculate the 3day moving average if the cell contains zero value

[farhansaleem]

Hi, I am trying to calculate the 3-day moving average in excel. And I want excel to not calculate the moving average if any one day (out of 3 days of daily precipitation data) contains a zero value. Can anyone help and guide thanks

Regards,

Farhan

 

[JamesCanale]

MrExcelPlayground12.xlsx
	A	B
1	Rain	3-day moving average
2	0.5
3	0.4
4	0.3	0.40
5	0.1	0.27
6	0
7	0.2
8	0.3
9	1	0.50
10	0.2	0.50
11	0
12	0
13	0.1
14	0.1
15	0.5	0.23
Sheet25

Cell Formulas
Range	Formula
B4:B15	B4	=IF((A2<>0)*(A3<>0)*(A4<>0),AVERAGE(A2:A4),"")

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 3 day moving average
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[JamesCanale]

The other websites solution was better than my ham-fisted attempt.

 

[farhansaleem]

MrExcelPlayground12.xlsx
	A	B
1	Rain	3-day moving average
2	0.5
3	0.4
4	0.3	0.40
5	0.1	0.27
6	0
7	0.2
8	0.3
9	1	0.50
10	0.2	0.50
11	0
12	0
13	0.1
14	0.1
15	0.5	0.23
Sheet25

Cell Formulas
Range	Formula
B4:B15	B4	=IF((A2<>0)*(A3<>0)*(A4<>0),AVERAGE(A2:A4),"")

Thank you @JamesCanale for the quick response

 

[farhansaleem]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 3 day moving average
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Dear Fluff next time i will follow the cross posting rules, thanks