If you want to make your data’s summary turn into a percentage to get a clear picture, you have come to the right place. In this blog, we will be talking about the summary or the findings of the count of the data which will be resulted in percentage.

Why percentage? Because the percentage is something that brings a clear picture, it gives us a feeling of accuracy, and you cannot deny that!

Previously: How to calculate the percentage variance quickly? 

So, let’s begin with the same and understand it through the help of an example:

Percentage Breakdown

As you can observe in the image above, we have taken product no. in reference to the market check and priority considered at that particular time.

On the other side, we have cut shorted the whole scenario and converted it into the summary. As you can see, we have counted the no. of times the following product no. has occurred in the range.

To count the same, you need to use:

=COUNT(

Percentage Breakdown

Now there are two ways of doing it, first is with the availability of count.

If you already have the summary data in your pocket, then your half of the work is done, so all you have to do is start with the equal to sign as it’s the starting to every formula and select the summary count in your hand.

Percentage Breakdown

Then, you need to divide the same by the COUNTA Function.

=COUNTA(

In this, value 1, value 2, and so on… are required.

Percentage Breakdown

Just like in the image above, we will select the product range i.e. C2:C14.

Percentage Breakdown

Overall, it makes our formula as follows:

=I5/COUNTA(C2:C14)

Percentage Breakdown

Now, all you have to do is press enter. So, the conversion of summary count into percentage breakdown becomes 30.77% for Product 201.

Percentage Breakdown

Now, comes the second method. In this method, we have used the COUNTIF Function as well as COUNTA Function. This method is used when you do not have summary count available, so by using the COUNTIF Function, it automatically adds the same instead of solving it separately.

Percentage Breakdown

The COUNTIF Function is as follows:

=COUNTIF(

The following function requires range as well as the criteria. So, the range is the product range i.e. C2:C14 and the criteria becomes the product number you are working on, in the example, product no. 202.

Percentage Breakdown

After the same we will close the COUNTIF Function and begin with COUNTA Function. As we have talked before about the same, so there’s no need to explain it again and again.

Percentage Breakdown

So overall, the formula becomes as follows:

=COUNTIF(C2:C14,H6)/COUNTA(C2:C14)

Percentage Breakdown

Now all we have to do is press enter and BAMMMM!!! The answer is 38.46%

So, you see, you can solve the same from both the ways. It’s up to you for if you want to create the summary count separately and then follow up into percentage breakdown or you want to include the summary count in the formula.

Percentage Breakdown

Just to confirm, you can always use the SUM Function to test whether the percentage breakdown has come out correctly or not.

*Please note: When you will use the above functions, be it through any method, after pressing enter i.e. completing the formula and implementing it, you need to select the same, go to number section and select the percentage format. Through this, your data will turn into percentage.

Hence, summary count with percentage breakdown.

Percentage Breakdown

It’s easy, isn’t it?