4. Countifs



 PROBLEM:  How to count the number of times of a specific value?


=2.IF([@CODE]="";"";1.COUNTIFS([CODE];"="&[@CODE];[Type];"<>"&"";[DATE];"<>"&""));
  1.  Counts the values of the columns code and type equal to the cell of the respective row and with a date different from "";

  2.  If cell is  " "  the result will be  " ".


    3. It is used to count the number of times a specific value appears in a table, given certain conditions.

    Here is a breakdown of the formula:

    1.  IF([@CODE]="";""; - This checks if the cell in the CODE column of the current row is empty. If it is, then the formula returns an empty string. If it is not empty, then the formula continues to the next part.


    2.   COUNTIFS([CODE];"="&[@CODE];[Type];"<>"&"";[DATE];"<>"&"")) - This counts the number of times the value in the CODE column of the current row appears in the CODE column of the entire table, but only if the Type and DATE columns of the same row are not empty.


    3.   The & symbol is used to concatenate the = sign with the value in the CODE column, so that it only counts exact matches.
COUNTIFS

Countifs - Syntax

COUNTIFS (range1, criteria1, range2, criteria2)

For example: The result for the first cell:

At our table:

Destiny 2
2