Average

[geosp]

Hello, 
i have a simple question. I want to calculate the average with this style:  first sum the amounts of column A which have been multiplied with the amounts of column B, and then divided by the sum of column B. i.e. (A1xB1)+(A2xB2)+(A3xB3)/((B1+B2+B3)= AVERAGE. 
Could you tell me what can i do?

[#2]

@geosp 

That is called weighted average. The idea is here https://www.excel-easy.com/examples/weighted-average.html, you may google Excel weighed average for more samples

[#3]

Thanks a lot for the response.