This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to reference a column total from a table that's in another sheet and it's throwing a "There's a problem with this formula error" . The formula I'm using for that is =TableName[[#Totals],[TableColumn]], I have checked the table and column names and they seem correct. Am I doing something wrong? Is there another way to do that that's not using a direct cell reference?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Do as follows:
In your sheet type a = into a cell (do not press ENTER)
Switch to the other sheet
Click into the total cell, then press ENTER
Andreas.
It just worked, oddly enough, considering i tried that before and it gave me a direct cell reference. Looks like the problem was i was using a comma instead of a semicolon. Thanks!
Try changing the table to a range and then back to a table and then click in the cell.
If i try clicking on the cell it gives a direct reference(Sheet1!B8). I typed it with the help of the formula auto completion.
That should work. Are you typing it out, or clicking the cell to get the reference?