Summary Count Of Non-Blank Categories With COUNTIFS
COUNTIFS function This is one of the statistical function that counts the number of cells in a range. However, the function counts cells that meet single or multiple criteria. The function can also be used to count non-blank cells/category.
=COUNTIFS(range1, criteria1, range2, “<>”)
Example of How COUNTIFS Function Works
To get a summary count of non-blank categories with COUNTIFS function, the process is very simple. In this example, we are going to look at a summary of three construction using the COUNTIFS function: Check the screenshot below:
Figure 1. Example 1 of COUNTIFS Function
How COUNTIFS Formula Works
From this example, the summary count of non-blank categories works is pretty simple. The formula in H6 is:
From the generic formula, the criteria_range1 is B5:B11. It returns a count of matching sites on column B only.
To count site inspection, the formula is extended by an additional range/criteria pair which looks like this
….in this, the criteria_range2 C5:C11, which is an absolute reference, and criteria2 is “<>” meaning “not empty” or “not blank.” So the formula in G6, it can be translated to count of entries where the site is J and inspection is not blank.
Similarly, we can count approvals per construction site using COUNTIFS Formula in I6:
You will notice that the first range/criteria pair is the same, but the second pair counts non-blank entries in D column D (D5:D11).