Empty table row count

[PhilHickey]

Hello Everybody, newbie here.
I have a simple question re Excel Tables. The following Excel formula returns a count of rows in a Table's databody range: =ROWS(Table1[#Data]). This works perfectly unless the table is emptied. When I expect to see a count of zero it returns 1. This has been bugging me for some time. Any help much appreciated.
TIA
Phil

 

[JEC]

for example

=LET(t,Table1[Data]+0,MIN(t,ROWS(t)))

 

[Peter_SSs]

Welcome to the MrExcel board!

A table cannot have zero rows in its data body range. So what exactly are you trying to achieve?
As well as a general more detailed explanation perhaps you could also refer to the following diagrams and tell us what result you would expect for each one and why?

A.

B.

C.

D.

E.

F.

G.

@JEC
Your formula returns 1 for the table in G above which doesn't seem to be answering the request. (It also errors if the 'Data' column is not numerical.)