EXTENDING A NAMED RANGE

I have a range of cells in a sheet that is named, and formulas in a different sheet refer to that range. I inserted a row into the middle of that range (had an entry to add), and now one row at t...

excel

nabilmourad

MVP

Aug 14, 2019

janaki223

Definitely you can use the table name in formulas

We call it "Structured Table Reference"

Example: If you convert a list into a Table >> Then name it "Source". Automatically the columns are named by their Column Headers.

If Among the columns you have : Date, Manager, Region, Amount (these are the column Headers)

You can create a SUM function to Sum the Amount as follows

=SUM(Source[Amount])

Source being the Table Name

Amount being the Field name

Not only Excel recognizes the Table name (Source) but also the Column Names. You must include the column name in square brackets. It also appears in the intellisesnse list of Excel

Hope that Helps

Nabil Mourad