Conditional averages

[JoboM]

Hi there,

I've got a table full of data that requires a running average calculation. The running average should only apply to the 10 previous data entries, however the issue I'm facing is that quite often for any given day there is no data entry, therefore, in order to capture the 10 previous data entries, the row (cell) range that the average calculates over is variable.

Is there a way to capture the previous 10 data entries in the average regardless of blank cells?

Thank you

I hope everyone is well!

Jobo.

 

[Aladin Akyurek]

Try to provide a scaled-down example sample along with results that you expect to see.

 

[nahidking]

=(SUM(A1:J1))/(COUNT(A1:J1)-COUNTIF(A1:J1,0))

try this formula in the cell where u want your average. and then paste is down in rest cells by pulling it down.