Yes, it is possible to use additional tables, whether on the same sheet or on additional sheets, to perform analysis on the response table. There are several ways to refer to the response table from other tables:
='Response Table'!'First Name'
Refers to a column called "First Name" in the response table. Single quotes are only needed if the name contains spaces or other special characters. Another variant of this is
Which refers to the column denoted by the letter B above the column name. In both of the above cases, there is an implicit correlation between the row number in the response table and the row number in the new table. If you wish to refer to specific cell in the response table, you can use the familiar syntax for accessing cells, in which the row being referred to is explicitly defined:
You can then build formulas using these references. You may also use summary functions that refer to the entire column using the @ syntax, for example:
Hope this helps,
Excellent, Thanks Eylon!
Is there any place that I can find a listing of the syntax for the formulas to use with the table cell references you have noted above?
Is it possible to run a summary report (charts/graphs) off of a newly created table or sheet?
Summary reports can only be created for the response table.
Is there a limit to the # of columns that you can add to the repsonse table?
The response table can contain up to 500 columns.