The average turnover for each country.

[Daniel2022]

Hey there
Could you please help write a formula to find the average turnover of customers from each country

I tried =AVERAGEIF(A2:A91061,A2,B2:B65759) but it shows DIV/0. My goal is to find average turnover for 'LV' etc.

Thank you

 

[Peter_SSs]

Welcome to the MrExcel board!

It looks like your numbers in column B might be text values not numerical values.

Try these steps

1. Make sure column B is formatted as General
2. Put a 1 in a vacant cell somewhere
3. Copy that cell with the 1 in it
4. Select B2 down to the bottom of your data
5. Home ribbon tab -> click the drop-down arrow under Paste -> Paste special... -> select Multiply -> OK

Now see how your existing formula goes.