Formulas to Count with Percentage Breakdown in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-11-20 12:05:20

---
title: Formulas to Count with Percentage Breakdown in Excel Office 365!!
published: true
date: 2020-11-20 11:55:44 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-with-percentage-breakdown-in-excel-office-365/
---

This page will guide you to learn the simple **formulas used to generate a summary count with percentage breakdown in Excel Office 365**. Let’s get into this article!!  
Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count with a percentage breakdown](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/EXCEL_fNY5JIoYzR.png)](https://geekexcel.com/?attachment_id=17763#main)<figcaption id="caption-attachment-17763">Formulas to count with a percentage breakdown</figcaption>
## General Formula:

- To generate a count with a percentage breakdown, you can use the below formula.

**=COUNTIF(range,criteria)/[COUNTA](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/)(range)**

## Syntax Explanations:

- **COUNTIF** – In Excel, this function will help to count the number of cells that meet a single condition or criteria.
- **COUNTA** – This function counts the number of cells that are non-empty and returns the output in numbers. Read more on the [**COUNTA Function**](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/).
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input range from your worksheet.
- **Criteria** – It is the condition that is used to count the values.
- **Division (/)** – It is used for dividing values or numbers.

## Example:

- In the below image, we will show how to count the percentage breakdown in Excel.
- First, we will give the input ranges in **Column B and C**.
- Then, enter the given formula.
- Finally, it will display the result in **Cell F3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-48.png)<figcaption id="caption-attachment-17684">Example</figcaption>

## A Brief Summary:

This page gives you a detailed view of the **formulas used to create a count with a percentage breakdown in Excel Office 365**. Hope that you like this article. If you feel this article is useful to you, then leave your **feedback** in the below **comment** section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Formulas to Create a Summary Count by Month with COUNTIFS Function](https://geekexcel.com/formulas-to-create-summary-count-by-month-with-countifs-function/)**
- **[Excel Formulas to Count Cells Equal to Case Sensitive Values!!](https://geekexcel.com/excel-formulas-to-count-cells-equal-to-case-sensitive-values/)**
- **[Formulas to Count Multiple Criteria and OR Logic with COUNTIFS!!](https://geekexcel.com/formulas-to-count-multiple-criteria-and-or-logic-with-countifs/)**
- [**Excel Formulas: Summary Count of the Non-Blank Categories!!**](https://geekexcel.com/excel-formulas-summary-count-of-the-non-blank-categories/)