Excel Average

[m7081]

i would like to calculate the average of each shop as well as the total.
what would I have to do so that I only get the average of REWE and all of rewe

[#2]

@m7081 AVERAGEIF and SUMIF can do this. Please see a simplified example attached.

[#3]

@m7081 

As variant that could be Pivot Table

[#4]

I am learning Excel atm, i will try it. thank you guys