If that is indeed your formula, in Cell C2 you should get the multiplied value of A2 and B2. If you don’t want to use so many cells like this, you can multiple values themselves to.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

In excel; A B C D E F total % I would like to take the whole % and distribute it among A-F and multiply the resulting % by the number that is in column A - F ••• Quote Report F ...