| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table names in formulas in Excel 2007
In Excel 2007, I get an error when trying to use table names in formulas. Eg.
I am trying to 'Sum' a column of figures whose heading is 'Jan' and I have entered the function as =SUM(Jan). The option 'Use table names in formulas' has been activated. Jan 223 223 114 =(Sum)Jan The result is #NAME? The same procedure works perfectly in Excel 2003. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table names in formulas in Excel 2007
Hi Misha,
You need to put the name of the table first, and the name of the column in square brackets, ie. =sum(Table1[Jan]) -- Hope this helps "Misha" wrote: In Excel 2007, I get an error when trying to use table names in formulas. Eg. I am trying to 'Sum' a column of figures whose heading is 'Jan' and I have entered the function as =SUM(Jan). The option 'Use table names in formulas' has been activated. Jan 223 223 114 =(Sum)Jan The result is #NAME? The same procedure works perfectly in Excel 2003. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disappearing Names in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| Excel 2007 - Dynamic names for chart series | Charts and Charting in Excel | |||
| Need tips on new features in Excel 2007 pivots, names, views | Excel Worksheet Functions | |||
| Excel 2007 defining names (areas) | Excel Worksheet Functions | |||
Linear Mode
