New Contributor

# Average

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 Replies

# Re: Average

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

# Re: Average

Thanks a lot for the response.