Count Functions


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 cellsdownwards 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).

img1


  • CountDown.SK function can be used with various function such as reshape, filldown, serialnumber, etc.
  • Working :-

    • Arguments of some functions require height of the region, we can use CountDown.SK function get the height.
    • 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.SKfunction, as shown in the figure below :

img2


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).

img3


  • CountRight.SK function can be used with various function such as reshape, fillright, etc.
  • Working :- o Arguments of some functions require width of the region, we can use CountRight.SK function get the width. o For example, the FillRight.SK function requires Width argument, we can use CountRight.SK function here. Provide the CountRight.SK function in the Width argument of the FillRight.SK function,as shown in the figure below :

img4