AverageIF ignoring empty cells

[Konkol]

Hi guys,

I need to calculate the average price per week from the column 'calc avg'
If i use the AverageIF formula i get the div/0 error.
i have empty spaces in the column but there is no way i can get them out of the original document.
so i need to calculate the average per week while it disregards the empty cells for those weeks
im lost and hope you guys can help

thx in advance

[way2020]

Please show the formula you are using with the empty spaces and the resulting answer