Count Line Items in a Table

[BrianExcel]

I am trying to count the number of line items in a table. When I am in the worksheet and enter COUNT(A2:A52) it results in 0.

But when I look at the formula, instead of the count and range, I see:

=COUNT(SevenDaySummaryData[Venue])

This is because it's a table and the header value is "Venue".

How can I do a simple count in the table that won't show as 0?

 

[Peter_SSs]

Sounds like the data in that column might be text and not numerical. Try

=COUNTA(SevenDaySummaryData[Venue])

 

[sandy666]

time to learn

COUNT function - Microsoft Support

How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.

support.microsoft.com

COUNTA function - Microsoft Support

Syntax: COUNTA(value1,value2,...)

support.microsoft.com

COUNTBLANK function - Microsoft Support

Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.

support.microsoft.com

COUNTIF function - Microsoft Support

How to use the COUNTIF function in Excel to count the number of cells that meet values you set.

support.microsoft.com

 

[BrianExcel]

Thanks Peter! That worked perfectly.

One more question - how do I then massage that into VBA to use worksheet function? I have it currently set as Double, with the following:

dim VenueCount as Double
VenueCount = WorksheetFunction.COUNTA(SevenDaySummaryData[Venue])

When I do that it highlights the "[Venue]" and then says "expected ("

 

[Peter_SSs]

Since the count will be a whole number, I would declare VenueCount as Long, not Double (though that has nothing to do with your error).
Try

VenueCount = WorksheetFunction.CountA(Range("SevenDaySummaryData[Venue]"))

 

[BrianExcel]

That did it perfectly. Thanks Peter!

 

[Peter_SSs]

That did it perfectly. Thanks Peter!

You're welcome.