Counting up how many streams are flowing into it

[LostinExcel80]

I have inherited a set a data that is laid out as followed and I am wanting to count the cells to the right and down until they hit another cell in the same column a lot will be 0 as they will have no streams into them. While long term maybe to redo that data into a better layout this is what I have and need to work with for now. Each stream in data 1-7 will always only have one line filled, but a unique name...

DATA 1	DATA 2	DATA 3	DATA 4	DATA 5	DATA 6	DATA 7	number of streams under stream. (I need this row formula for dynamic as streams are added and removed)	---->alot more data not needed for this example but is relevant to the specific stream
Final stream A							2
	Second to final stream A						1
		Third to final stream A					0
Final Stream B							5
	Second to Final stream B A						0
	Second to Final stream B B						0
	Second to Final stream B C						0
	Second to Final stream B D						1
		Third to final stream B D A					0

For this example, if there is a value in cell A1, count all cells to the right and down that contain data UNTIL it hits a value in A again.
I am pulling hair trying to figure this out.

The logic is this as follows but I can't figure that out in excel

DATA 7 should always count as 0
DATA 6 should count all DATA 7 directly under it until DATA 6 or DATA 5 or DATA 4 or DATA 3 or DATA 2 or DATA 1 is not blank,
DATA 5 should count all DATA 6 and DATA 7 directly under it until DATA 5 or DATA 4 or DATA 3 or DATA 2 or DATA 1 is not blank,
DATA 4 should count all DATA 5, DATA 6 and DATA 7 directly under it until DATA 4 or DATA 3 or DATA 2 or DATA 1 is not blank,
DATA 3 should count all DATA 4, DATA 5, DATA 6 and DATA 7 directly under it until DATA 3 or DATA 2 or DATA 1 is not blank,
DATA 2 should count all DATA 3, DATA 4, DATA 5, DATA 6 and DATA 7 directly under it until DATA 2 or DATA 1 is not blank,
DATA 1 should count all DATA 2, DATA 3, DATA 4, DATA 5, DATA 6 and DATA 7 directly under it until DATA 1 is not blank

Please help thank you...

 

[Peter_SSs]

Are we confused here?

I asked earlier if a vba solution would be acceptable and you basically said no. Since then we have spent a deal of time developing a formula approach & the last one does not require any particularly recent Excel version. Are you saying that it is now not acceptable or doesn't work or did you think it still required Excel 365 with the latest dynamic array functions like FILTER & SEQUENCE?

 

[LostinExcel80]

Sorry I thought the last formula required newer 365 that was my misunderstanding...

 

[LostinExcel80]

Thank your for all you help!

 

[Peter_SSs]

Sorry I thought the last formula required newer 365 that was my misunderstanding...

I was hoping it was just a misunderstanding.

Thank your for all you help!

You're welcome.