autosum column from worksheet

[Gale Gorman]

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

I am on a tab named "Recap" and I want the sum of column N
from sheet 1 named "Bill of Material."

Thanks,

Gale Gorman
Houston

 

[Tom Ogilvy]

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