3-Getting more advanced - fixing error
Download
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