Formula to Derive Table Row Count

[medberg]

Hey Everyone,

I need a formula to place in a cell that will determine the number of data rows in an Excel table. I have been using ROWS(Table1) which works perfectly except for the fact that it returns 1 even when there is no data in the table. How else could I go about doing this? Thanks in advance.

 

[Jonmo1]

I think it's because a table MUST contain at least 1 row, otherwise it's not really a table is it...

Perhaps try

=COUNTA(Table1[Header1])

 

[medberg]

That reasoning makes sense I guess, it just seems inconsistent (e.g. in VBA ListRows.Count on am empty table returns 0). Anyways, your recommendation works great because I do have a field which will always be populated. Thanks!