Calculating average demand interval

[samosangudu]

Hello All,
Please, can anyone help me calculate average demand interval in the attached file. I'm working on inventory classification project.

Thank you.

[PaulM100]

No results in your sheet and the explanation is vague. Try this guess: =IFERROR(SUMIF($C4:$N4,">"&0,$C4:$N4)/COUNTIF($C4:$N4,">"&0),0)