Worksheet - how to count number of non-empty cells?

[unearthed]

HI all

So I have a sparse worksheet (most cells are empty), and all I want to do is count the filled cells in the columns i.e. I just want a cell at each column base that says 7, 9, 3, 15 etc. As in the mockup image encl. I'm on Windows 2012 if it matters.

 

Active cell contents are calculations from other cells, and sometimes manually entered numbers, and in case it matters the function in a cell looks like this. But Ideally I'd also like to be able to count plain text-filled cells later on.

=(INT((K$7*$D$5*$A$30)/5)*5)+5

Edited September 14, 2021 by unearthed
title change

[Pat Stanford]

Going to be very difficult to do. It might be possible using a "worksheet script", but I don't think there is a way to do it at all if you have a "database" section to the worksheet as there is no way to access the values of the subrows.