So say I have 3 sections of data seperated by a blank row like this:
Text
Text
-blank-
Text
Text
Text
-blank-
Text

I want to count how many rows are in each section (which are seperated by blank rows):
The output should be in 3 different cells like so:
2
3
1

I'm really stuck on how to do this, the closest I've come is the following which can only count the first section of data:
=MIN(IF(C:C="",ROW(C:C)))-ROW(C1)