Count Down & Count Right

We may encounter scenarios where we need the count of dynamic vertical/horizontal range, we can achieve this by using SheetKraft count functions.

Count functions are dependent and not stand-alone functions i.e., they are used with other functions in order to achieve a specific result.

CountDown.SK :

CountDown.SK function returns the height of the region of non-blank cells downwards from the specified row

range.

CountDown.SK function has one argument - Row_range : Select the row range where all cells within the range

belong to the same row(this can also be a single cell).

Fig.: 1.1 CountDown.SK function argument
  • CountDown.SK function can be used with various functions such as reshape, filldown, serialnumber, etc.

  • Working :-

o Arguments of some functions require height of the region, we can use the CountDown.SK function to get the height.

o For example, the FillDown.SK function requires Height argument, we can use CountDown.SK function here. Provide the CountDown.SK function in the Height argument of the FillDown.SK function, as shown in the figure below :

Fig.: 1.2 Use of CountDown.SK function

CountRight.SK :

  • CountRight.SK function returns the width of the region of non-blank cells rightwards from the specified column

  • range.

  • CountRight.SK function has one argument - Column_range : Select the column range where all cells within the range belong to the same column(this can also be a single cell).

Fig.: 1.3 CountRight.SK function argument
  • CountRight.SK function can be used with various functions such as reshape, fillright, etc.

  • Working :-

o Arguments of some functions require width of the region, we can use CountRight.SK function to get the width.

o For example, the FillRight.SK function requires Width argument, we can use the CountRight.SK function here. Provide the CountRight.SK function in the Width argument of the FillRight.SK function, as shown in the figure below :

Fig.: 1.4 Use of CountRight.SK function

Related links on YouTube:

CountDown SK and CountRight SK Tutorial - https://youtu.be/gjDMs763aXU