Average

%3CLINGO-SUB%20id%3D%22lingo-sub-1555405%22%20slang%3D%22en-US%22%3EAverage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555405%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CBR%20%2F%3Ei%20have%20a%20simple%20question.%20I%20want%20to%20calculate%20the%20average%20with%20this%20style%3A%26nbsp%3B%20first%20sum%20the%20amounts%20of%20column%20A%20which%20have%20been%20multiplied%20with%20the%20amounts%20of%20column%20B%2C%20and%20then%20divided%20by%20the%20sum%20of%20column%20B.%20i.e.%20(A1xB1)%2B(A2xB2)%2B(A3xB3)%2F((B1%2BB2%2BB3)%3D%20AVERAGE.%26nbsp%3B%3CBR%20%2F%3ECould%20you%20tell%20me%20what%20can%20i%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1555405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555428%22%20slang%3D%22en-US%22%3ERe%3A%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744609%22%20target%3D%22_blank%22%3E%40geosp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20called%20weighted%20average.%20The%20idea%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fweighted-average.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fweighted-average.html%3C%2FA%3E%2C%20you%20may%20google%20%3CEM%3EExcel%20weighed%20average%3C%2FEM%3E%20for%20more%20samples%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555441%22%20slang%3D%22en-US%22%3ERe%3A%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555441%22%20slang%3D%22en-US%22%3EThanks%20a%20lot%20for%20the%20response.%3C%2FLINGO-BODY%3E
New Contributor

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

@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

Thanks a lot for the response.