Forum Discussion
Solved
create dynamic range of table including headers and footers
Hello, I'm using Office 365 on Windows 10. I wanted to create a Dynamic Named Range of a Table called Table1, including it's Headers and Footers (Totals Row). By Default, when you enter the D...
The range consisting of the header row + the data rows is Table1[[#Headers],[#Data]]
The range consisting of the header row + the data rows + the total row is Table1[#All]
The range consisting of the data rows + the total row is Table1[[#Data],[#Totals]]
= Table1[#All]
will return headers and the totals row. For calculation
= Table1
is more useful.