How Excel calculates the proportions of the account

With the use of Excel functions, we can easily calculate the proportion of a product in the same or total product.

Here is an example that you want to help with.

Computer Tutorials

As pictured above, what we want to calculate is how much the proportion of men's and women's clothing is in the same style.

For example, A2 cell is a male, and its data is 100, then, the corresponding 100 data, in the male section of all the data, the proportion of the amount?

The method is simple, enter the formula directly:

=B2/SUMIF ($A $: $A $11,a2, $B $: $B $11)

can solve the problem.

Now let's analyze the formula:

The use of SUMIF is: SUMIF (data Lookup range, what to look for, find the sum of the data to which the corresponding range is returned)

SUMIF ($A $: $A $11,a2, $B $: $B $11) Calculates the total number of all men's money.

Note that, in the above formula, $B $: $B $11 The references to these cells as an absolute reference, which ensures that the data range is not changed by filling the fill tool down.

Knowledge Extension:

If you want the above results to appear as data with a percent semicolon, you can change the formula to read as follows:

=B2/SUMIF ($A $: $A $11,a2, $B $: $B $11) *100 & "%"