I need to count how many cells in a column contain anything, hence not
counting blank ones.

=COUNTIF(range,criteria)

what would the criteria be?