Excel: Structured table reference & column names. Column names not recognized. 1

[rccline]

I have created a table in excel using Ctl+t

The headers appear filtered.

If I try to create a formula referencing the table, I get the name of the table automatically, but I cannot get the names of the columns.

=sum(tbl_Sales) the named table "tbl_sales" appears and I can use tab to autofill. But that is as far as I get.

=sum(tbl_sales[ and no dropdown. If I fill in with the column name, I get a broken formula error.

I have tried: =sum(tbl_sales[@[ no dropdown. Again, if I complete the formula with the column name, I get a broken formula error.

In design view, the header row is checked; filter button is checked and the entire range, including column names is highlighted.

It is surely something simple, but what I do not know. What am I missing?

Thank you.

2Rowdy

 

[SkipVought]

Hi,

Please upload your workbook. I'll take a look.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[rccline]

Thank you Skip. The issue I am inquiring about is contained in a workbook from a free online instructional video which is copyrighted.

To demonstrate the problem I was having,I created a different table for you in a new worksheet. ...but, the function I am trying to learn, works!
I don't know what the issue is with the workbook from the online course, but the problem is contained within the workbook sheet itself. I can copy that sheet to a new workbork and the issue remains.

I guess we can consider the issue resolved.

Again, thank you.

2Rowdy

 

[SkipVought]

Well the upstory is that you're getting into the Structured Table feature which is one of Excel's neatest features, packed with all kinds of goodies from Santa.

You'll find new stuff in Structured Tables, like new unknown reindeer you never knew existed. For centuries people thought there were only 8. Then they found Rudolph. But wait! There's more! Olive, the other reindeer; they shouted out with Glee; Santa came to Say for advice; the most famous reindeer Ofall.

Merry Christmas!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]