Table names in formulas in Excel 2007

M

Misha

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
 
J

JudithJubilee

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Excel Sum Function 3
Pivot table problem 4
Time Sum in Excel 1
using sumifs with multiple criteria? 3
SUMPRODUCT Not Working 2
Column 1 Column 2 in Microsoft Excel 2007 2
Apparently missing in Excel 2007 4
Adjusting formula for month in vlookup? 3

Top