using structural table's columns

[lezawang]

Hi
I have a table like below. I highlighted and then Insert-->Tale.
I click on a cell outside the table and wrote

=sum([revenu])

But I got an error message? Why is that? when I can use Structural table columns? (for example [name], [store], [item]
Thank you very much

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]name[/TD]
[TD="class: xl63, width: 64"]store[/TD]
[TD="class: xl63, width: 64"]item[/TD]
[TD="class: xl63, width: 64"]revenu[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD]east[/TD]
[TD]computers[/TD]
[TD="align: right"]2272[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]west[/TD]
[TD]fridge[/TD]
[TD="align: right"]3337[/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD]north[/TD]
[TD]stove[/TD]
[TD="align: right"]1660[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[TD]south[/TD]
[TD]dryer[/TD]
[TD="align: right"]1601[/TD]
[/TR]
[TR]
[TD]linda[/TD]
[TD]east[/TD]
[TD]washer[/TD]
[TD="align: right"]2993[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

You need to specify Table: Change the red font to match the name of your table.

=SUM(Table1[revenu])

 

[MARK858]

Deleted as should have refreshed the screen then would have seen the previous post