Table names in formulas in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Misha - 26 Mar 2008 06:26 GMT

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 to this Message

JudithJubilee - 26 Mar 2008 09:11 GMT

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

Signature

Hope this helps

> 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
[quoted text clipped - 8 lines]
> The same procedure works perfectly in Excel 2003.
> Thanks

Reply to this Message