Empty cell with a formula in an excel report

An excel sheet is made of empty cells and each time I fill a cell, there are less empty cells but sometimes, when I extract a data from a tool, amongst the cells with data, there are some empty ones and I may need to know which one and how much.

formula excel

 

When I use the formula ?

When I need to show which one and how much.

 

How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".

 

How are the formulas ?

=IF()

=COUNTBLANK()

=COUNTA()

=COUNTIF()

=COUNTIFS()

To display if the cell is empty or not:

=IF(A2<>"","not empty","empty")

To count empty cells amongst cells with data:

=COUNTBLANK(A2:A11) or =COUNTIF(A2:A11,"<>*")

The other way is to count cells that are not empty:

=COUNTA(A:A) or =COUNTIF(A:A,"*")

To count empty cells for a specific product:

=COUNTIFS(B:B,"",A:A,"chocolate")

The other way is to count cells that are not empty for this specific product:

=COUNTIFS(B:B,"<>",A:A,"chocolate")

Interesting Management