# Learn How to Create Summary COUNT of Non Blank Categories in Microsoft Excel

Written by | 0 Comments | 406 Views

In this article, you will learn how to COUNT various things in Microsoft Excel using a single or combination of functions and its purpose. You will also get to know how to Create a Summary COUNT of Non Blank Categories and see the generic formula.

Create Summary COUNT of Non-Blank Categories in Microsoft Excel

The main purpose of this formula is to build a summary count of non-blank categories. Here we will learn how to create a summary count of non-blank categories in Microsoft Excel. That implies, with the help of a formula based on the COUNTIFS function you can able to build a summary count of non-blank categories. So, with the help of this formula, you can able to create a summary count of non-blank categories.

General Formula to Create Summary COUNT of Non-Blank Categories

=COUNTIFS(range1,criteria1,range2,"<>")

The Explanation for the Create Summary COUNT of Non-Blank Categories

So we know that with the help of the given formula above you can able to create a summary count of non-blank categories. Here we will learn how to create a summary count of non-blank categories in Microsoft Excel. As we know that the example provided here relies on core COUNTIFS functionality. To create a summary count by building we need to use COUNTIFS as shown in the example. To count inspections by building, we need to extend the formula by adding an additional range/criteria. Similarly, to count approvals per building, we use this formula. So, with the help of this formula, you can able to create a summary count of non-blank categories.