Prompt 1

Write an Excel formula to sum the values in a column named total. The name of the table is in a cell

Prompt 2

I'm getting a #ref error for the table named New Zealand

Prompt 3

The table name in the cell contains spaces but the actual table name uses an underscore instead of a space. Please update the first formula you provided to fix this issue

Prompt 4

Please explain how this formula works in less than 50 words