Table names in formulas in Excel 2007

  • Thread starter Thread starter Misha
  • Start date Start date
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
 
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
using sumifs with multiple criteria? 3
Excel "Worksheet Name" Building Function for Summary Sheet 2
sumproduct with date range 4
Time Sum in Excel 1
excel formulas 2
Pivot table problem 4
summarizing data from various workbooks 3

Back
Top