autosum column from worksheet

[Gale Gorman]

I am trying to autosum a column from another worksheet and
don't know the syntax.

On sheet "Recap" I am trying to put the sum of column N from
sheet "Bill of Material."

Thanks,

Gale Gorman
Houston

 

[Tom Ogilvy]

=Sum('Bill of Material'!N:N)