Does not seem to be a defined table. TABLE does not show up in defined
names as it does when I define one of my own. Also doesnt look like
structured reference syntax-- such as =SUM(Table1[[#Data],[amount]])
-- which uses brackets.
I cant access you tube at work but will check those videos out at home
this weekend.